Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.
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