Create a filter pane that excludes instead of Include

[robin_heijt]

Hi,

I was wondering if through set analysis of some sorts I can create a filter pane that instead of creating a selection will create a exclusion.

I know it is possible to select excluded in the filter menu, but I want it to be more efficient that if i select something in the filter pane, the selection will immediately be excluded.

Thanks.

[robin_heijt]

This picture is a screenshot of my filter pane with names.

Normally when I select a name it filters on this specific person.

What I would like to achieve is that when I select a name, instead of selecting this person it will exclude the person. So if I would select Laura in this list, it will exclude her from the selection and select everyone else.

[sunny_talwar]

But this exclusion is needed in a chart with some kind of expression, right? or are you looking for a dashboard wide solution?

[robin_heijt]

Hi Sunny,

No it would not be specific to a chart. Now I indeed understand the logic of your set analysis.

What I would want is to have a dashboard wide exclusion.

So if I would select Laura in the previous example, I do not want her information to be shown throughout the entire dashboard.

[sunny_talwar]

So, in that case you need an AND mode filter pane... check here

Generating AND, OR , NOT selection logic in Qlik Sense

[sunny_talwar]

Actually the above link is doing this using set analysis as well. I am not sure if there is an AND mode in Qlik Sense. But this was available in QlikView (AND-Mode) which would have made it possible for you to do it across the dashboard.

[robin_heijt]

Thanks Sunny, Unfortunately this does not seem to be an option in Qlik Sense.

Thank you for explaining the logic anyway. I will have to look forward to a feature like this then.

Cheers