Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
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