Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
TomBond77
Specialist
Specialist

Chart type "KPI" negative value -> red

Hi experts

I have this value as master item "Diff" and use it for a KPI chart:

Sum(actual) - Sum(budget) 

To get red colour I defined the KPI measure as follows:

if(([Diff])<0, red(), green())

But this is ignored and the value thereafter also is wrong.

Any ideas?

Labels (3)
1 Reply
Or
MVP
MVP

That's... not how KPI measures work, I believe.

Your measure should be Diff. Color should be set using Appearance / Color / Conditional Colors with a single limit set at 0.