topic Re: Button - select excluded values in QlikView

Button - select excluded values

Fri, 19 Sep 2014 10:04:26 GMT

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?

Re: Button - select excluded values

Gysbert_Wassenaar — Fri, 19 Sep 2014 10:07:35 GMT

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.

Re: Button - select excluded values

tresB — Fri, 19 Sep 2014 10:08:45 GMT

Try 'select in field' like:

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

Re: Button - select excluded values

Fri, 19 Sep 2014 10:21:31 GMT

that worked. Thanks Gysbert!

Re: Button - select excluded values

Tank — Fri, 08 Mar 2024 15:41:09 GMT

This solution works! Thank you, Tresesco.