How can i set up this filter ?

Question

I want to allow users to input a text field with items separated by commas (e.g.,

X1,X2,X3,X4,X5

) and, after clicking a boolean (e.g., "Select"), have the page filtered to show data only for the specified items. How can I set up this filter?

Rnilsson · Answer

Hi,

I think we need a bit more information of what X1, X2 is representing.

If those are list members then I would sugest this solution instead.

1)

Have a Boolean added to an ADMIN module (no dim). ("confirm choice/select")

2)

Have a module (FIL01) dimensioned by your list

1 "Filter Line item"  (formatted as a boolean) = should have no formula

2 "Filter Confirmed Picks" = If not "ADM01.select" then true/false (depending on how you want it to operate) else "Filter Line Item"

Here they can select the items manually (instead of typing).

Still want to add typing?

Add SYS Lookup: "Item to find" (formatting text)

Then you can add another filter to FIL01

"Find Item" = Name(item(L1)) = sys lookup.'item to find'

Then add this as a filter to the UX-card.

This would allow users to search for an item, then check the boolean and search for another item.

You could add a lot more logic to have a dynamic search function, but this is probably the most you need.

Does this work for you?

Best,

Rickard