Qlik Community

Qlik Sense App Development

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

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
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
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
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