Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
emilyrabbit
Creator
Creator

filter not impact single chart

Hi team, 

I met the below problem:

when I select the single year, the chart dimension"Year" will change to the selected year automatically . Could I fix the year , not impacted by the year select .Thanks.

emilyrabbit_0-1729648392815.png

 

Labels (2)
1 Solution

Accepted Solutions
Qrishna
Master
Master

Keep all the dims as they are and try modifying your expression something like this: Sum({<Year=>}Field) and you should have all the years on the x axis even when a year is selected. this expression is ignoring year selections. If you want to ignore Yearmonth selections too: Sum({<Year=,Yearmonth =>}Field).

2488554 - Ignore Current Selection in Dimension (1).PNG

 

2488554 - Ignore Current Selection in Dimension (2).PNG

View solution in original post

4 Replies
Lisa_P
Employee
Employee

You can fix this in your expression by ignoring selections on the Year using Set analysis

Just insert this before your expression : {<Year>}

This is in effect saying that you always want all years.

emilyrabbit
Creator
Creator
Author

emilyrabbit_0-1729662946190.png

Hi I got your point . But this chart, there are four diemensions. Could I restrict only I select dimension=year, then set the expression. Thanks.

Lisa_P
Employee
Employee

You could ignore all selections by using {1}

Qrishna
Master
Master

Keep all the dims as they are and try modifying your expression something like this: Sum({<Year=>}Field) and you should have all the years on the x axis even when a year is selected. this expression is ignoring year selections. If you want to ignore Yearmonth selections too: Sum({<Year=,Yearmonth =>}Field).

2488554 - Ignore Current Selection in Dimension (1).PNG

 

2488554 - Ignore Current Selection in Dimension (2).PNG