Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Hoowling
Contributor III
Contributor III

Change chart expression based on selection

Hi community! 

I would like alter the chart expression based on the list box selection made. 
The expression I would like to be dynamic is: 

=Avg({<[Info Bransch]=P({$} [Info Bransch])>}[EBIT-marg Senaste])

Where [EBIT-marg Senaste] should change given my selection in the list box (EBIT-marg Senaste is a dimension). 

THankful for any help!

12 Replies
chrismarlow
Specialist II
Specialist II

Hi,

Should be;

=Avg({<[Bolagsnamn]=,[Info Bransch]=P({$} [Info Bransch])>}[$(=varLönsamhet)])

Cheers,

Chris.

Hoowling
Contributor III
Contributor III
Author

Hi, 

Something is not working properly with that expression:
(ps. changed  field name from bolagsnamn to bolag). 

 

Snipaste_2019-02-22_07-00-39.png

chrismarlow
Specialist II
Specialist II

Hi,

I don't understand how that variable works. If you put it in a text box does it show the value you want?

Cheers,

Chris.