Selecting "not" values via a button

[QlikSensor]

Hi,

today I have learned how to setup a QlikSense Button which selects more than one value by just writing

(String1|String2)

Now I want to setup a button which selects the alternatives which means everything except String1 and String2. Is this possible in QlikSense?

[JordyWegman]

Hi,

You can select nulls in you want this:

Powered by Matthew Fryers.

Jordy

Climber

[QlikSensor]

Hi, thanks for the quick answer. I don't want to filter out null values but if I would take your example I want to filter out just Sally. Therefore I need a button which filters NOT Sally.

[bramkn]

Use set analysis and have the selection made with the button be set to a variabele used in the set analysis. so {<name-={'$(VariableofVariablebutton)'}>}

[QlikSensor]

Hm, could you explain this in detail? I don't know how to use "set analysis"...

[bramkn]

Ah ok. Do you know how to use the buttons to fill a variable? if so:
in your calculation/measure you can use this:
sum({<Name={'$(VariableofVariablebutton)'}>}YourFieldNameToSum)

[QlikSensor]

--> Do you know how to use the buttons to fill a variable?

Unfortunately not 😞

I thought it's as easy as write (George|Sally)

[rwunderlich]

You can accomplish the "not" selection with 2 actions: First, select the values, second action "select excluded". 

It's also possible to do it with a single compound selection like this:

(* ^ (String1|String2))

I use this doc https://community.qlik.com/t5/QlikView-Documents/Compound-Search-demystified/ta-p/1494410 as the definitive guide to compound search. 

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

[QlikSensor]

Thanks for sharing. This works really great. It doesn't select exactly the alternatives but it's something I can live with.

[rwunderlich]

It's a NOT selection, so yes, it's not the same as selecting alternatives. If you want a true alternatives selection, use the "Select Alternatives" action in the button. 

-Rob