topic Re: Filter to Exclude years in Visualization and Usability

Filter to Exclude years

Pragya — Sun, 20 Feb 2022 22:09:16 GMT

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

Re: Filter to Exclude years

Lisa_P — Sun, 20 Feb 2022 22:55:00 GMT

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

Re: Filter to Exclude years

Pragya — Sun, 20 Feb 2022 22:56:59 GMT

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

Re: Filter to Exclude years

Lisa_P — Sun, 20 Feb 2022 23:03:02 GMT

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

Re: Filter to Exclude years

Pragya — Mon, 21 Feb 2022 05:33:22 GMT

Thankyou Lisa_P 🙂

It works