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