Qlik Community

New to Qlik Sense

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

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
cancel
Showing results for 
Search instead for 
Did you mean: 
YG
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()

 

YG_0-1600157525516.png

 

I used the expression, what I got from community.

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

YG_1-1600157714355.png

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