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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Je12emy1
Contributor
Contributor

Conditional with on AGGR function

I'm trying to change the background color for each cell based on a conditional where if each value is greater than the AVG total the cell background must be blue.

Je12emy1_0-1587322576240.png

I already managed to extract the AVG for each total.

Je12emy1_1-1587322674879.png

This is the expression I used

Je12emy1_2-1587322842318.png

 

Then I tried to combine these two in a conditional but I still dont get the desired value, I think each value returned by the aggr function is not being looped though for each cell?

Je12emy1_3-1587322895111.png

 

Labels (1)
0 Replies