topic Re: How to show zero when null value in QlikView https://community.qlik.com/t5/QlikView/How-to-show-zero-when-null-value/m-p/970690#M332359 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Try to put a zero in the "Missing Symbol" field in the Presentation Tab of your object.</P><P>Regards,</P><P>Vincent</P></BODY></HTML> Tue, 10 Nov 2015 14:46:19 GMT vincent_ardiet 2015-11-10T14:46:19Z How to show zero when null value https://community.qlik.com/t5/QlikView/How-to-show-zero-when-null-value/m-p/970688#M332357 <HTML><HEAD></HEAD><BODY><P>hi huys</P><P></P><P>enclosed a document that show - when value is null</P><P></P><P>how can i make it show&nbsp; 0</P><P></P><P>as when we export to excel there is lot of work to do to replace&nbsp; - to 0</P><P></P><P>thanks</P><P></P><P>gidon</P></BODY></HTML> Tue, 10 Nov 2015 14:38:54 GMT https://community.qlik.com/t5/QlikView/How-to-show-zero-when-null-value/m-p/970688#M332357 gidon500 2015-11-10T14:38:54Z Re: How to show zero when null value https://community.qlik.com/t5/QlikView/How-to-show-zero-when-null-value/m-p/970689#M332358 <HTML><HEAD></HEAD><BODY><P>On the Chart Properties|Presentation tab, set the Missing Symbol to zero.</P></BODY></HTML> Tue, 10 Nov 2015 14:46:10 GMT https://community.qlik.com/t5/QlikView/How-to-show-zero-when-null-value/m-p/970689#M332358 m_woolf 2015-11-10T14:46:10Z Re: How to show zero when null value https://community.qlik.com/t5/QlikView/How-to-show-zero-when-null-value/m-p/970690#M332359 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Try to put a zero in the "Missing Symbol" field in the Presentation Tab of your object.</P><P>Regards,</P><P>Vincent</P></BODY></HTML> Tue, 10 Nov 2015 14:46:19 GMT https://community.qlik.com/t5/QlikView/How-to-show-zero-when-null-value/m-p/970690#M332359 vincent_ardiet 2015-11-10T14:46:19Z Re: How to show zero when null value https://community.qlik.com/t5/QlikView/How-to-show-zero-when-null-value/m-p/970691#M332360 <HTML><HEAD></HEAD><BODY><P>See if this helps:</P><P></P><P><IMG __jive_id="105014" alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/105014_Capture.PNG" style="height: 622px; width: 620px;" /></P></BODY></HTML> Tue, 10 Nov 2015 14:47:34 GMT https://community.qlik.com/t5/QlikView/How-to-show-zero-when-null-value/m-p/970691#M332360 sunny_talwar 2015-11-10T14:47:34Z Re: How to show zero when null value https://community.qlik.com/t5/QlikView/How-to-show-zero-when-null-value/m-p/970692#M332361 <HTML><HEAD></HEAD><BODY><P>Hi gidon, PFA.</P><P></P><P>I unchecked the option to supress zeros. AS a result it shows all the PN# so I changed it to a calculated dimension to show only the values with quantity or $</P></BODY></HTML> Tue, 10 Nov 2015 14:49:28 GMT https://community.qlik.com/t5/QlikView/How-to-show-zero-when-null-value/m-p/970692#M332361 rubenmarin 2015-11-10T14:49:28Z Re: How to show zero when null value https://community.qlik.com/t5/QlikView/How-to-show-zero-when-null-value/m-p/970693#M332362 <HTML><HEAD></HEAD><BODY><P>thanks you guys</P><P>you are all great</P><P>gidon</P></BODY></HTML> Tue, 10 Nov 2015 14:53:57 GMT https://community.qlik.com/t5/QlikView/How-to-show-zero-when-null-value/m-p/970693#M332362 gidon500 2015-11-10T14:53:57Z