topic How to replace zero values with blank? in QlikView https://community.qlik.com/t5/QlikView/How-to-replace-zero-values-with-blank/m-p/200311#M58886 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Does anybody know how to replace the zero values with blank wehn setting up a chart object?</P><P>Any help will be very much appreciated. Thanks in advance!</P></BODY></HTML> Thu, 01 Apr 2010 09:47:35 GMT 2010-04-01T09:47:35Z How to replace zero values with blank? https://community.qlik.com/t5/QlikView/How-to-replace-zero-values-with-blank/m-p/200311#M58886 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Does anybody know how to replace the zero values with blank wehn setting up a chart object?</P><P>Any help will be very much appreciated. Thanks in advance!</P></BODY></HTML> Thu, 01 Apr 2010 09:47:35 GMT https://community.qlik.com/t5/QlikView/How-to-replace-zero-values-with-blank/m-p/200311#M58886 2010-04-01T09:47:35Z How to replace zero values with blank? https://community.qlik.com/t5/QlikView/How-to-replace-zero-values-with-blank/m-p/200312#M58887 <HTML><HEAD></HEAD><BODY><P>hi,</P><P>you can uncheck "suppress zero values" in chart properties 'presentation' tab to display null values.</P><P></P><P>and use</P><P>set nulldisplay=' ';</P><P>to represent your null values.</P><P></P><P>thanks</P><P></P></BODY></HTML> Thu, 01 Apr 2010 09:57:06 GMT https://community.qlik.com/t5/QlikView/How-to-replace-zero-values-with-blank/m-p/200312#M58887 2010-04-01T09:57:06Z How to replace zero values with blank? https://community.qlik.com/t5/QlikView/How-to-replace-zero-values-with-blank/m-p/200313#M58888 <HTML><HEAD></HEAD><BODY><P>HI</P><P>Could you possibly explain where in the script this should go?</P><P>Cheers</P><P></P></BODY></HTML> Wed, 30 Jun 2010 08:48:13 GMT https://community.qlik.com/t5/QlikView/How-to-replace-zero-values-with-blank/m-p/200313#M58888 2010-06-30T08:48:13Z How to replace zero values with blank? https://community.qlik.com/t5/QlikView/How-to-replace-zero-values-with-blank/m-p/200314#M58889 <HTML><HEAD></HEAD><BODY><P>You dont have to do anything in the script, use a dual function for your expression in the chart:</P><P>Dual( if(exp=0,' ', exp),exp)</P><P></P></BODY></HTML> Wed, 30 Jun 2010 11:33:16 GMT https://community.qlik.com/t5/QlikView/How-to-replace-zero-values-with-blank/m-p/200314#M58889 kji 2010-06-30T11:33:16Z