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

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Nagaraju_KCS
Specialist III
Specialist III

Pie Chart?

Is it possible to show negative values on pie chart?

3 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Yes, but you can't show negative and positive values at the same time. That's meaningless anyway in a pie chart so that shouldn't be a problem.


talk is cheap, supply exceeds demand
Nagaraju_KCS
Specialist III
Specialist III
Author

Thanks Gybsert,

Got a Problem I don't want to show negative values on pie chart, please help me. Below is the output of showing negative values.

got this problem (Positive and Negative values in chart)

erichshiino
Partner - Master
Partner - Master

HI,

How do you want to handle negatives?

If you just want to ignore them, you can set negatives to zero using rangemax()

if your expression is sum(value), you can use rangemax( sum( value), 0 )

It will compare sum(value) and 0 and get the max of them.. Thus, the minimum value is 0, replacing negative values.

Is it enought? If not, please, let us know

Regards,

Erich