coloring a KPI based on another calculation

[ali_hijazi]

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

[thomaslg_wq · Accepted solution]

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