Skip to main content

New to Qlik Sense

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

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ext_bay
Employee
Employee

Set KPI limit that changes color based on comparison

Hi all,

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!

1 Solution

Accepted Solutions
ext_bay
Employee
Employee
Author

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

3 Replies
ext_bay
Employee
Employee
Author

And the Limit is dynamic, based on the user date selection

ext_bay
Employee
Employee
Author

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

OmarBenSalem

ur KPi have 2 expressions:

expression1

expression2

now, go to colors:

for the first expression1:

add limit: expression2:

Capture.PNG

and visversa :

Capture.PNG