topic delete 0 values in pie chart in QlikView https://community.qlik.com/t5/QlikView/delete-0-values-in-pie-chart/m-p/677916#M676037 <HTML><HEAD></HEAD><BODY><P>Hi, how do I delete zero values in pie chart as shown below? Thanks.</P><P></P><P><IMG alt="Untitled5.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/61413_Untitled5.png" /></P></BODY></HTML> Mon, 30 Jun 2014 07:29:18 GMT 2014-06-30T07:29:18Z delete 0 values in pie chart https://community.qlik.com/t5/QlikView/delete-0-values-in-pie-chart/m-p/677916#M676037 <HTML><HEAD></HEAD><BODY><P>Hi, how do I delete zero values in pie chart as shown below? Thanks.</P><P></P><P><IMG alt="Untitled5.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/61413_Untitled5.png" /></P></BODY></HTML> Mon, 30 Jun 2014 07:29:18 GMT https://community.qlik.com/t5/QlikView/delete-0-values-in-pie-chart/m-p/677916#M676037 2014-06-30T07:29:18Z Re: delete 0 values in pie chart https://community.qlik.com/t5/QlikView/delete-0-values-in-pie-chart/m-p/677917#M676038 <HTML><HEAD></HEAD><BODY><P>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.</P></BODY></HTML> Mon, 30 Jun 2014 07:32:25 GMT https://community.qlik.com/t5/QlikView/delete-0-values-in-pie-chart/m-p/677917#M676038 Gysbert_Wassenaar 2014-06-30T07:32:25Z Re: delete 0 values in pie chart https://community.qlik.com/t5/QlikView/delete-0-values-in-pie-chart/m-p/677918#M676039 <HTML><HEAD></HEAD><BODY><P>But it's 0.00% so doesn't it mean it's non-existent? So why does it still show in the chart?</P></BODY></HTML> Mon, 30 Jun 2014 08:29:10 GMT https://community.qlik.com/t5/QlikView/delete-0-values-in-pie-chart/m-p/677918#M676039 2014-06-30T08:29:10Z Re: delete 0 values in pie chart https://community.qlik.com/t5/QlikView/delete-0-values-in-pie-chart/m-p/677919#M676040 <HTML><HEAD></HEAD><BODY><P>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%')</P></BODY></HTML> Mon, 30 Jun 2014 08:42:56 GMT https://community.qlik.com/t5/QlikView/delete-0-values-in-pie-chart/m-p/677919#M676040 Gysbert_Wassenaar 2014-06-30T08:42:56Z