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: 
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)