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: 
Not applicable

Change the chart color if...

How can I change the "circles" color of my scatter chart if the value of n expression was...

=if(sum(NPS)/count(NPS)>8) Then the color should be Green

=if(sum(NPS)/count(NPS)<6) Then the color should be Red

=if(sum(NPS)/count(NPS)>6<8) then the color should be Gray

I've tried this expression in the Backgound color of my Expression

=if(sum(NPS)/count(NPS)>8,argb(180,0,128,0),if(sum(NPS)/count(NPS)<=6,argb(180,255,0,0),argb(180,128,128,128)))

But it's not working.


So, what is going on?

Thanks for your help

1 Reply
Not applicable
Author

I think it's a bug, but the color of the "circle" is not defined in the "Z" axis or in the Dimension axis, but in the "X" axis...

2011-05-11_180855.png