Skip to main content
The way to achieve your own success is the willingness to help somebody else. Go for it!
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Qlik Sense - Using a Variable Value to get different colors for Negative/Positive numbers

Hi Qlikers,

I am pretty new to Qlik and I seems to be having a challenge getting different colors for Negative and postie numbers. I have read so many posts on this and I used the same expressions but non of it seems to changed the colors.

I have Variable name  = v_P1-P3 YoY

I want Colors Negative = Green()

I want Colors positive = Red()




I used the expression, what I got from community.

if($(v_P1-P3 YoY)<0,green(),red())


However, the expression is validating is but color is not changing to green as per the formula. What am I doing wrong here? Anyone who can help would be really appreciated. Thanks 















Labels (3)
0 Replies