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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
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.