Dashbord enum-list filtering

[TobiasN]

Hi!

New user in need of some guidance.
"Dashbord filter[Program]" is a Enumlist text basetype with suggested values from "DUMP FRÅN DRIVE[Program]".

"[Dumpis]" is a VC_Enumlist ref basetype with app formula "Select(DUMP FRÅN DRIVE[Program],[_THISROW].[Grupp- nummer]=[Grupp- nummer])"

The selection works. But only for one selection. If I select two or more from the enumlist, I get a "No items".

What I want is to show a list of tools connected to each Program.
So if two or more Programs is selected. The list for those programs should be shown.
I'm stuck!

  My slice Row filter condition.

OR(
    ISBLANK(Dashbord filter[Program]),
    IN(Dashbord filter[Program], [Dumpis])
  )

 

[Marc_Dillon]

---

@TobiasN wrote:

IN(Dashbord filter[Program], [Dumpis])

---

It's because this is a list-of-lists. You need to flatten it to a single list type. To do so, convert it to text, then split it back.

SPLIT( TEXT( Dashboard filter[program] ) , " , " )

[TobiasN]

Yaa i thought it was something like that. Could just not get my head around it.
If I select a singel program it works. The table data tester shows the tools as "Y".

If i multiselect, and the programs have the same tools. It shows up like it should in the app. But not in the Table data test window. Everything shows as "N".
If i select two programs with different tools connected. I get a list of 2 tools and its missing the rest. The table data tester shows all as "N"

[Marc_Dillon]

Oh, your IN() is backwards too. First argument is the single item, second is the List.

https://help.appsheet.com/en/articles/2357277-in

[TobiasN]

One week later and alot of hair loss, and I still can't get this to work!

Im trying to filter out a long list of tools connected to the programs im picking in the "Dashbord filter[Program]" enumlist selectionbox.
"Grupp- nummer" is the tools im searching for.

The [Dumpis] is a VC column with appformula: Select(DUMP FRÅN DRIVE[Program],[_THISROW].[Grupp- nummer]=[Grupp- nummer])
This seems to do what i want.

______________________________________
DUMP FRÅN DRIVE - table

Program     Grupp- nummer     ID
...
0299461T2          243         0299461T2243
0299461T2         241         0299461T2241
0299461T2         815         0299461T2815
0299461T1         239         0299461T1239
0299461T3         119         0299461T3119
0299461T3         118         0299461T3118
0299461T3         801         0299461T3801
0299461T3         242         0299461T3242
0299461T3         815         0299461T3815
0299461T3         513         0299461T3513
0299569T1         201         0299569T1201
0299569T2         241         0299569T2241
0299569T2         243         0299569T2243
0299569T2         817         0299569T2817
0299569T2         501         0299569T2501
0299569T2         118         0299569T2118
0299569T2         120         0299569T2120
....
_____________________________________

Selection of programs 0299461T2, 0299569T2
Should show these tools in the dashbordview.

118
120
241
243
815
817
501

But im not really sure its the [Dumpis] I should use as "list-to-search". Maybe just a formula, but the ones ive tried have not made any sense.

[Marc_Dillon · Accepted solution]

Hmmm, I think I missed what the definition of [Dumpis] was from the beginning. It's another list. So you're comparing 1 list against another? You want the record to appear if there is even a single common element between the lists? Use:

ISNOTBLANK( INTERSECT( 
  [dumpis] ,
  SPLIT( TEXT( ....
) )

[TobiasN]

Woke up in the middle of the night and thought I figured it out.
The 'Dump från Drive' is a excel power query, and it was not sorted correctly. Did that. Nothing change really.
But I can now see that it kinda works.
If I select Program1, it gives the right list of tools for that program. If i add Program2 to the enumlist. It only shows the tools that is both in Program1 and Program2. Nothing else.
Program1(1, 3, 4, 5, 6) Program2(1, 2, 5, 7)
It filter out (1, 5)
I whould like it to show (1, 2, 3, 4, 5, 6, 7)
And if all program was selected, it should show ALL tools.

This fomula is what is giving me this.

Tried to change the order, then nothing works like it should.

OR(
	ISBLANK(Dashbord filter[Program]),
    IN(SPLIT(TEXT(Dashbord filter[program])," , "), [Dumpis])
)

Tried Intersect(), but cant get it to work... "subexpressions must be Yes/No conditions"

[Marc_Dillon]

---

@TobiasN wrote:

Tried Intersect(), but cant get it to work... "subexpressions must be Yes/No conditions"

---

Thus why I included ISNOTBLANK() in my suggested expression.

[TobiasN]

DUH! I missed that, thought it was a part of ISBLANK(Dashbord filter[Program])...

Thank you for the help! It worked immediately. Perfect! 🙌