Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
ali_hijazi
Partner - Master II
Partner - Master II

coloring a KPI based on another calculation

Hello
I'm working on latest version of Qlik Sense
I got a KPI in which I'm displaying the remaining days of a resource

Now I need to color the value of the KPI based on the value of another expression which is calculated via a variable called vCycleTime
now if $(vCycleTime) is between 0.1 and 0.2 then orange else if < 0.1 then red else green

is this doable?

Kindly advise

I can walk on water when it freezes
1 Solution

Accepted Solutions
thomaslg_wq
Creator III
Creator III

You can try to use the dual function.

Dual(

num([your measure to show in kpi], '# ##0'),

[your measure that affects colors]

)

Then select the format number as "expression"

 

Then in the coloring section : color is affected by the second measure in the dual function

View solution in original post

1 Reply
thomaslg_wq
Creator III
Creator III

You can try to use the dual function.

Dual(

num([your measure to show in kpi], '# ##0'),

[your measure that affects colors]

)

Then select the format number as "expression"

 

Then in the coloring section : color is affected by the second measure in the dual function