Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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

Re: delete 0 values in pie chart

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

Re: delete 0 values in pie chart

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

Re: delete 0 values in pie chart

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
Community Browser