Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Strwbryshwty
Partner - Contributor
Partner - Contributor

Color Condition within condition

Hello, 

I am trying to create a KPI card that displays Yes or No if my cost = delivered. I am trying to display it so that if it’s Yes it’s in blue and if it’s No it’s in Red. However I cannot figure out how to change the color depending on Yes or No. please advise 

Labels (2)
1 Reply
MatheusC
Specialist II
Specialist II

Maybe this, in your script, creates a status field through your cost field.

MatheusC_0-1728326727811.png


In the KPI you will need a numeric expression to enable the configuration of conditional colors, so work with the Match() function, it returns numeric values ​​from your Status field.

dual(only(Status),match(Status,'Yes','No'))

 - Enter the expression and change it to Measure expression

MatheusC_3-1728326940858.png

 

On the Color tab, set the color to 1 – Yes, 2 – No

MatheusC_4-1728327256674.png


Result:

MatheusC_1-1728326766454.png

MatheusC_2-1728326781624.png

 


Note the solution above is just an example according to the information provided, so you will certainly need to make some adjustments.


- Regards, Matheus

Did you find a solution to your question? Mark the solution as accepted and if you found it useful, press the like button!