If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
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!
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
View solution in original post
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 :