Filter to Exclude years

[Pragya]

Hi All, 

I have Arrival year in my dashboard from 2010 -2021. I want to create a filter in my dashboard heading "Exclude Years" whose purpose is to exclude the years clicked and NOT select the years clicked. 

Can anyone help?

Thanks

[Lisa_P]

You can create a button with the action to select excluded values from the Year field and label it as such

[Pragya]

I am new to Qlik. Could you please tell me how?

[Lisa_P · Accepted solution]

On the sheet in edit mode, Select Charts from the Assets panel on the left and drag the button object onto the sheet

In the Actions and navigation section of the Properties panel on the right, add a new action, pull down the action options to Select excluded, then select the field to apply this to.

Then go to Appearance, General and modify label with your description of what the button will do eg. Select excluded Years

[Pragya]

Thankyou Lisa_P 🙂

It works