Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

Using Filter Pane to filter data

Question about Qlik Sense:

Out of a list of 100 names I would like to use a Filter Pane to select the names which I would like to filter out in my visualisations, instead of selecting 99 names.

Searching for similar questions on this Community did not lead to a concrete answer to this question.

Is this for example possible using single dimensions?

Could anyone help me doing this?

1 Solution

Accepted Solutions
brian_booden
Not applicable

Re: Using Filter Pane to filter data

Hi Eveline,

In your example, select the single value that you do not want to include, and then click on the title of a filter pane and open the Selection Menu (the ellipses), you will see the the option "Select excluded".  You can use that to select the inverse of what you currently have selected.

I hope that's what you're looking for.

Regards,

Brian

4 Replies
brian_booden
Not applicable

Re: Using Filter Pane to filter data

Hi Eveline,

In your example, select the single value that you do not want to include, and then click on the title of a filter pane and open the Selection Menu (the ellipses), you will see the the option "Select excluded".  You can use that to select the inverse of what you currently have selected.

I hope that's what you're looking for.

Regards,

Brian

NickHoff
Not applicable

Re: Using Filter Pane to filter data

You can also use a set.

=aggr(only({1-$}FieldName),FieldName)

Not applicable

Re: Using Filter Pane to filter data

Didn't expect it was this easy! Thanks!

Not applicable

Re: Using Filter Pane to filter data

Im trying to use your answer, but it didnt work out. What exactly do you mean by set? Where should I enter it?