topic coloring a KPI based on another calculation in App Development

coloring a KPI based on another calculation

ali_hijazi — Thu, 09 May 2019 10:21:53 GMT

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

Re: coloring a KPI based on another calculation

thomaslg_wq — Thu, 09 May 2019 12:19:26 GMT

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