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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Nolgath
Creator
Creator

Only react to 1 filter in filter pan

I have this expression: 

avg({$<dealer=>}{1<country=country>}currentPrice)

This is working, the problem is, it is avg of all column of "country", I need to to react to my filter pan, so when I choose AT it only shows avg of current price of AT and so foward.. 


Is there any way? 

Labels (6)
2 Replies
JordyWegman
Partner - Master
Partner - Master

Hey,

Can you add your application maybe? It's easier for us to test.

Jordy

Climber

Work smarter, not harder
rui24
Creator
Creator

The {1} -> Select all data

The {$} -> Only select the selecte data

Try to change the 1 by the $

avg({$<dealer=>}{$<country=country>}currentPrice)