Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor
Contributor

Changing filter for a single visualization

I have a single slide that has three visualizations on it. They are identical but I’d like to view different fiscal years. The problem is that when I change the fiscal year on one, it changes on all three visualizations. I’d appreciate any suggestions on how to proceed.

THANKS, John

2019-03-19 I've discovered I'm having the same problem when the three visualizations are on different slides as well.  I've read a little about "Alternative States" and we will get the version of Quik Sense which has this in a few months.  Will that be an easier way to solve this problem?  ~ John

2 Replies
Luminary
Luminary

Hi,

If you want to ignore a filter in Qlik Sense  you could try using set analysis in your expression.

Example:

if you want to ignore selections for the dimension called Year in a sum function for a measure called quantity then the function would be  Sum( {$<Year=>} Quantity )

 

Partner
Partner

You need to use set analysis to fix a fiscal year for each. Change your expressions to something like below
chart 1 Sum({< FiscalYear= {'2018'}> }Measure)
chart 2 Sum({< FiscalYear= {'2017'}> }Measure)