Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
cancel
Showing results for 
Search instead for 
Did you mean: 
QlikSensor
Partner - Creator
Partner - Creator

Selecting "not" values via a button

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?

11 Replies
QlikSensor
Partner - Creator
Partner - Creator
Author

OK, my post was misleading. I don't want to have the alternatives but based on the current selection excluding some values. Currently the button ignores the current selection of this dimension and applies all values except the given. 

Anyway, I probably have to live with that. And again, thanks for sharing, your link is pretty helpful in a couple of other scenarios.

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

That kind of selection is possible as well. Assume your field is "Country" and you want the button to exclude "Brazil" and "Canada".  Your search/select string would be:

='("' & concat({<Country-={'Canada','Brazil'}>}DISTINCT Country, '"|"') & '")'

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