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

Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
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