Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
See why Qlik is recognized as a Leader for the 10th year in a row – and discover how Qlik can help put your business in the lead. Get Report
Partner
Partner

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
Highlighted
thomaslg_wq
Contributor III

Re: coloring a KPI based on another calculation

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
Highlighted
thomaslg_wq
Contributor III

Re: coloring a KPI based on another calculation

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