Discussion board where members can learn more about Qlik Sense App Development and Usage.
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:
(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.
Go to Solution.
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.
View solution in original post
So there is no work around methode?
If we use the simple KPI extension there can only be one colour for the value colour?
how do you assign colors to this? setting the expression is the limit. can you please explain in detail?
So could you further explain or clarify how you did this?
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