Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
melperso21
Contributor II
Contributor II

Apply a filter that does not affect the entire bar chart

Hello,

I need to apply a filter that does not affect the first option in the bar chart, but rather keeps the same value in view, while the other options change in relation to the filter that I apply

melperso21_0-1655496735899.png

Who can help me?

Thanks in advance

Labels (1)
1 Reply
Aditya_Chitale
Specialist
Specialist

Try using if() statement and nullify the filter field in your set expression.

if(Dimension='Session_Start', sum({<Filter_Field=>}Sales)  , sum(Sales))

 

Regards,

Aditya