Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

delete 0 values in pie chart

Hi, how do I delete zero values in pie chart as shown below? Thanks.

Untitled5.png

3 Replies
Gysbert_Wassenaar

On the Presentation tab is an option Suppress Zero-Values. If that is enabled then no 0 values will be shown. If you still see 0 values then those are not precisely 0. Perhaps you need to use a floor() function to round them down to 0.


talk is cheap, supply exceeds demand
Not applicable
Author

But it's 0.00% so doesn't it mean it's non-existent? So why does it still show in the chart?

Gysbert_Wassenaar

No, for example the value 0.000002 is not equal to zero. Not even if you format it so it displays in the format 0.00%. Try it in a textbox: =num(0.000002,'0.00%')


talk is cheap, supply exceeds demand