Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Button - select excluded values

Is it possible with a button to select everything EXECPT two values.

I can work out how to do one, as you do a simple 'Select in Field' action followed by a 'Select Excluded' action.

But when I try and insert a 'Toggle Select' action between those two actions it seems to be ignored.

What am I doing wrong?

1 Solution

Accepted Solutions
Gysbert_Wassenaar

You can try selecting the two values first with a search string like ("Value1"|"Value2") and then follow that up with the Select Excluded action to invert the first selection.


talk is cheap, supply exceeds demand

View solution in original post

3 Replies
Gysbert_Wassenaar

You can try selecting the two values first with a search string like ("Value1"|"Value2") and then follow that up with the Select Excluded action to invert the first selection.


talk is cheap, supply exceeds demand
tresesco
MVP
MVP

Try 'select in field' like:

Search String= '('&Concat({<FieldName-={'Exclude1', 'Exclude2'}>} Distinct FieldName, '|') &')'

Not applicable
Author

that worked. Thanks Gysbert!