topic Re: Select all values from a filter pane not in a list via button in App Development

Select all values from a filter pane not in a list via button

eikenberg — Tue, 27 Feb 2024 13:32:37 GMT

Hello,

i have a filter pane with "LANDISOCODE" and want to select all entries except some in a list when i press a button.

List list is ~180 entries long and i want to exclude 4 entries.

I tried a button with action "Select values matching search criteria" and different versions of a function like

If(Match(LANDISOCODE, 'DEU', 'DEP', 'DE-', 'DE_'), Null(), LANDISOCODE)

='=(If(Match(LANDISOCODE, "DEU", "DEP", "DE-", "DE_"), Null(), LANDISOCODE))'

but none is working.

How can i do this?

Re: Select all values from a filter pane not in a list via button

singulariteetti — Tue, 27 Feb 2024 13:38:09 GMT

Hello,

In Qlik Sense, achieving a selection of all values from a filter pane excluding a specific list of values through a button action can be a bit tricky because of the way Qlik interprets set analysis and search criteria in actions. Unfortunately, directly using an If statement within a button action to exclude values might not work as expected due to the nature of how search strings are interpreted.

Create a Variable: First, you need to create a variable that holds the expression for the selection criteria excluding the specific codes. This variable will essentially generate a search string that includes all codes except the ones you want to exclude.
Use the Variable in Button Action: Then, you can use this variable within your button action to select values matching the generated search criteria.

Sponsored by ChatGPT - This explanation sounds reasonable to me.

Re: Select all values from a filter pane not in a list via button

Brian_C — Tue, 27 Feb 2024 13:38:31 GMT

Try

If(Not Match(LANDISOCODE, 'DEU', 'DEP', 'DE-', 'DE_'), Null(), LANDISOCODE)

Re: Select all values from a filter pane not in a list via button

Brian_C — Tue, 27 Feb 2024 13:40:56 GMT

In fact swap the Null and LANDISOCODE around if using not match in this way.

If(Not Match(LANDISOCODE, 'DEU', 'DEP', 'DE-', 'DE_'), Null(), LANDISOCODE)

Re: Select all values from a filter pane not in a list via button

Brian_C — Tue, 27 Feb 2024 13:44:57 GMT

Another solution would be in the script to create a flag by adding the line below:

If(not Match(LANDISOCODE, 'DEU', 'DEP', 'DE-', 'DE_'),'Y','N')as Include_Flag

then in the filter use Only(<{ Include_Flag={'Y'}>}LANDISOCODE)

Re: Select all values from a filter pane not in a list via button

eikenberg — Tue, 27 Feb 2024 14:24:34 GMT

That looks like the cleanest solution, i try it.

Re: Select all values from a filter pane not in a list via button

LRuCelver — Tue, 27 Feb 2024 14:27:24 GMT

An easy approach would be to use multiple actions to first select only the values you want to exclude and then inverting the selection:

Re: Select all values from a filter pane not in a list via button

eikenberg — Tue, 27 Feb 2024 14:31:35 GMT

Thanks.

It should be renamed to "Invert selection".

Re: Select all values from a filter pane not in a list via button

LRuCelver — Tue, 27 Feb 2024 14:37:48 GMT

There are two options for selecting other values: alternative and excluded values.

Alternative values are all values that could be selected with the current selections, but are not. They have a light gray background.

Excluded values are all values that you cant select because some other selection is blocking them. They have a dark gray background.