Deactivate filter

[JuDu1905]

Hello all,

I have installed a time filter at the top of my page. This filter should not have any effects / changes on a chart on the same page.

I would like to have the years 2018-2021 selected in the line chart, regardless of which filter is selected. If the filter changes, nothing should be changed in this diagram.

How is this possible? Many thanks in advance!

[Gysbert_Wassenaar]

You can do this with set analysis. Suppose your chart now contains a measure with the expression sum(Amount). To make that expression ignore selections in a field called Year and instead always make that expression use the years 2018 to 2021 you would change it to sum({<Year={2018,2019,2020,2021}>}Amount).

[JuDu1905]

Thank you for your answer!

Unfortunately it doesn't work for me yet, do you have an example or a guide / instruction I can follow?

[Gysbert_Wassenaar · Accepted solution]

Try using the search feature of this site.

Here's a search bresult to get you started: https://community.qlik.com/t5/Documents/Hands-on-Set-Analysis-from-the-ground-up/ta-p/1799118