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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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