Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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