Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
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