Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
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
MVP & Luminary
MVP & Luminary

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?

MVP & Luminary
MVP & Luminary

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