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

Announcements
Join us in Bucharest on Sept 18th 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)