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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Frinolav
Contributor II
Contributor II

Exclude value from dimension (freeze for filters)

Hi all !

I have a pie chart with one dimension "=[LINE-Packaging line]" and one measure "=[TU]".

I also have a filter on my sheet for the packaging line and when the filter is activated it also updates the pie chart.

I don't want the pie chart to be updated when the filter is activated and I don't know how to properly write it in the measure expression and there is only the column name.

Could you please help ?

Thank you sooooo much in advance 🙂

1 Solution

Accepted Solutions
Andrea_Spinetti
Former Employee
Former Employee

Hello @Frinolav, thank you for posting on the community! You can set a new "alternate state" and assign it to the chart you don't want to update. Have a look at our documentation on Using alternate states for comparative analysis. Cheers! 🙂

If the issue is solved please mark the answer with Accept as Solution.

View solution in original post

1 Reply
Andrea_Spinetti
Former Employee
Former Employee

Hello @Frinolav, thank you for posting on the community! You can set a new "alternate state" and assign it to the chart you don't want to update. Have a look at our documentation on Using alternate states for comparative analysis. Cheers! 🙂

If the issue is solved please mark the answer with Accept as Solution.