Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Everyone,
I wanted to understand if we can create a filter and on selecting the values, they get excluded (instead of only these values being selected as it works generally) from the entire visuals.
Is this possible directly or indirectly? Any help would be appreciated.
Hi There,
It is possible to indirectly in 2 ways :
1) You select the values & then in the more options of filter pane, you will do select excluded or alternative. That way you are technically excluding your selections from the dashboard.
2) You can also pass your desired selection in to a variable & call that variable in the e() to all the set expressions used in your dashboard. check out the following article :
https://community.qlik.com/t5/QlikView-App-Dev/P-E-and-where-do-you-use-them/td-p/457847
Regards,
Rohan.
You could also explorer the set {1-$} in you expressions. It will remove the selected state from everything (the inversion of the normal behaviour)
See documetation/example here: Qlik Help - Set analysis expressions
You can use exclude in the expression you want to invert the filter like:-
Sum({<Field1=e()>}Sales)
After this what you select will be excluded from the meausre calculation but also that when no filter is selected it will exclude every value.