Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

filter to exclude selection in Qlik Sense?

I need to use Filter pane to exclude the selected value for the field. How can I do it? Thanks!Smiley Happy

1 Solution

Accepted Solutions
Not applicable

Re: filter to exclude selection in Qlik Sense?

couldn't actually use any...

Ended up telling my stakeholders to use "Select Excluded" on the front-end when they use the filter.

Capture.PNG

10 Replies

Re: filter to exclude selection in Qlik Sense?

Use filter pane to exclude selected value? May be like this:

{<FieldName = e(ExcludedFilterFieldName)>}

jeckstein
Contributor

Re: filter to exclude selection in Qlik Sense?

I have done something similar to this. Im not sure if this will help, but maybe it will put you on the right path.

You can add a button in the caption to exclude current client.

          Listbox Properties> Caption>Special Icons>Select Exclude

One issue with this method is that you have to have the caption visible, and with some design standards, that is not possible.

Another way is to make a button that uses Select Exclude

     New Sheet Object>Button>Actions>Add>Selection>Select Exclude

Hope this helps!

-Jimmy

Not applicable

Re: filter to exclude selection in Qlik Sense?

Thanks Sunny but how should I use this? Please see below, and let me know what expression I should use in Filter pane?

My field1 includes values: A,B,C or D

When the user selects A, I want the sheets to NOT show A

When the user selects B, I want the sheets to NOT show B

Same for C and D

Re: filter to exclude selection in Qlik Sense?

Sheet or a particular chart? I guess how exactly are you using this?

Not applicable

Re: filter to exclude selection in Qlik Sense?

I have a Filter pane on the sheet. Not a particular chart. So the user wants this particular filter pane to work the opposite So when they click on 'A', everything in the app shows B,C,D data and not A. Let me know if it's not clear yet?

Not applicable

Re: filter to exclude selection in Qlik Sense?

Hi Jimmy, this is Qlik Sense, I think what you explained would work in Qlikview?

vinay_bangari
Valued Contributor III

Re: filter to exclude selection in Qlik Sense?

As far as i know there is no direct property you can set in the filter pane. All you can do is add set analysis in the each expression in your sheet to exclude the selection as stalwar1 suggested {<FieldName = e(ExcludedFilterFieldName)>}

danansell42
Contributor III

Re: filter to exclude selection in Qlik Sense?

There is another work around....

You could create a new field to use as a list box which links with all data except for the bit you want to exclude.

If you just have A B C and D its not difficult to create, however if its a long (or changing) list then it might not be suitable.

So as an example below i have loaded some random value against my field that i have called 'FLAG'.

I've then created a table below that links the value in FLAG to all values except the value selected.

You would put the 'NewFlag' as the filter box and the end result would be as you have requested.

//Loading random data to test concept

Data:

LOAD * INLINE [

    FLAG, Value

    A, 10

    B, 20

    C, 30

    D, 40

];

//Creation of New filter field

FilterTest:

LOAD * INLINE [

    FLAG, NewFlag

    A, B

    A, C

    A, D

    B, A

    B, C

    B, D

    C, A

    C, B

    C, D

    D, A

    D, B

    D, C

];

Hope this helps

Dan

danansell42
Contributor III

Re: filter to exclude selection in Qlik Sense?

Hi


Did any of the responses help solve your query?

Please mark one as correct to help other community users if it did.

Thanks

Dan

Community Browser