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