topic Re: Conditional colour formatting with Simple KPI Extension in App Development

Conditional colour formatting with Simple KPI Extension

Anonymous — Fri, 04 May 2018 04:58:43 GMT

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.

Re: Conditional colour formatting with Simple KPI Extension

Anonymous — Sun, 06 May 2018 23:30:50 GMT

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.

Re: Conditional colour formatting with Simple KPI Extension

jtvlanck — Fri, 06 Jul 2018 09:43:11 GMT

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?

Re: Conditional colour formatting with Simple KPI Extension

sammyak — Fri, 23 Nov 2018 14:16:04 GMT

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

Re: Conditional colour formatting with Simple KPI Extension

chriys1337 — Tue, 27 Nov 2018 13:33:10 GMT

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...?

Re: Conditional colour formatting with Simple KPI Extension

rxf67787 — Mon, 01 Apr 2019 17:23:38 GMT

Hello,

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

Re: Conditional colour formatting with Simple KPI Extension

amitvermancl — Fri, 26 Jul 2019 14:48:03 GMT

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