Qlik Community

Qlik Sense App Development

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

Highlighted
biggusdoggus
Contributor

Conditional colour formatting with Simple KPI Extension

Hey all.

So I have two Simple KPI "charts" in a visualisation.

One has Sum(Ref_React_Actuals_Measure), the other Sum(Ref_React_Target_Measure)


So far, so good - they both work fine, showing the right numbers.

However, what I want to do is have conditional colour formatting so if the Actuals is greater than the Target, the number is green, and red if it is below Target.

So I have this:

=IF (Sum(Ref_React_Actuals_Measure)

>

(Sum(Ref_React_Target_Measure)) , rgb(255, 128, 128), rgb(102, 204, 0))

But it doesn't work - it's red no matter if it's greater or below, or if I change the > to <.

What's wrong with it please? I'm using Qlik Sense Server.

1 Solution

Accepted Solutions
biggusdoggus
Contributor

Re: Conditional colour formatting with Simple KPI Extension

Worked it out. The Conditional colour formatting doesn't work the same was it does with tables etc.

For the Simple KPI extension, it looks for just a value for it be greater or less than.

So, setting the expression as simply (Sum(Ref_React_Target_Measure)) is the way to go - if the Actuals_Measure is below that value, it's red, and above, it's green.

6 Replies
biggusdoggus
Contributor

Re: Conditional colour formatting with Simple KPI Extension

Worked it out. The Conditional colour formatting doesn't work the same was it does with tables etc.

For the Simple KPI extension, it looks for just a value for it be greater or less than.

So, setting the expression as simply (Sum(Ref_React_Target_Measure)) is the way to go - if the Actuals_Measure is below that value, it's red, and above, it's green.

jtvlanck
New Contributor

Re: Conditional colour formatting with Simple KPI Extension

Hey,

So there is no work around methode?

If we use the simple KPI extension there can only be one colour for the value colour?

sammyak
New Contributor II

Re: Conditional colour formatting with Simple KPI Extension

how do you assign colors to this? setting the expression is the limit. can you please explain in detail?

chriys1337
Contributor II

Re: Conditional colour formatting with Simple KPI Extension

Could you explain it once more, please? You are not using a if-condition? How to give the parameter, like when its above green, otherwise red...?
rxf67787
New Contributor II

Re: Conditional colour formatting with Simple KPI Extension

Hello,

So could you further explain or clarify how you did this?

amitvermancl
New Contributor

Re: Conditional colour formatting with Simple KPI Extension

Hey,

Without the IF condition how can we compare the target and actual values.

I am also facing the issue with simple kpi extension, that unable to apply conditional formatting for a column