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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Variable which is only affected by one filter

Hello

I have looked at having Variables shown in a KPI that does not change when filters are applied

avg ({1}A)

But I am wondering if you can have it be able to be changed by a single filter such as Year

Thank you

2 Replies
sunny_talwar

Sure, try this

Avg({1<Year = $::Year>} A)

sunny_talwar

or this

Avg({1<Year = p(Year)>} A)