Discussion board where members can get started with Qlik Sense.
So I have a KPI like the one below:
Here the largest value is my CYTD Sales and the smaller value is the LYTD Sales. Now I want to set a limit and set colors as follows:
-- If CYTD is larger then LYTD it should be green and LYTD should be red
- If LYTD is larger that CYTD it should be green and CYTD should be red
I can't use rgb codes combined with an if statement in this case so I am wondering how to set the limit..
Thanks in advance!
Go to Solution.
Never mind I figured it out. The limit is just the expression that I want to compare with. So in case of CYTD the limit is the expression for LYTD
And the Limit is dynamic, based on the user date selection
ur KPi have 2 expressions:
now, go to colors:
for the first expression1:
add limit: expression2:
and visversa :