Qlik Community

Ask a Question

App Development

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

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
jerryr125
Professor-Ambassador
Professor-Ambassador

KPI Chart - display a number which is negative in red

Hi -

I have the following KPI :

Sum((ProductMonthlyTotalQuantitySold)-(ProductMonthlyForecastQuantity))

work perfect !

1. How do I display the KPI in red if the difference is less than 0 ?

2. How do I display the negative number in () ?

 

Thanks - Jerryr

1 Solution

Accepted Solutions
dilipranjith
Partner
Partner

Answer to 1 - KPI-->Colors--> Set conditional colors on. turn library colors off set limits on colors etc. (you can do this in master measure as well)
Answer to 2 - format number as custom use a format similar to #,##0.00;(#,##0.00)

View solution in original post

3 Replies
dilipranjith
Partner
Partner

Answer to 1 - KPI-->Colors--> Set conditional colors on. turn library colors off set limits on colors etc. (you can do this in master measure as well)
Answer to 2 - format number as custom use a format similar to #,##0.00;(#,##0.00)

View solution in original post

jerryr125
Professor-Ambassador
Professor-Ambassador
Author

thank you - perfect!!!
dilipranjith
Partner
Partner

No problems