topic Re: Null values as zero in QlikView https://community.qlik.com/t5/QlikView/Null-values-as-zero/m-p/411348#M153162 <HTML><HEAD></HEAD><BODY><P>In pivot tables and straight charts you can set the Null Symbol to a 0 on the Presentation tab of the properties window. You can also replace nulls with 0's in the script by adding these two lines at the top of the script:</P><P></P><P>NullAsValue *;</P><P>set NullValue=0;</P></BODY></HTML> Mon, 27 May 2013 14:11:32 GMT Gysbert_Wassenaar 2013-05-27T14:11:32Z Null values as zero https://community.qlik.com/t5/QlikView/Null-values-as-zero/m-p/411347#M153161 <HTML><HEAD></HEAD><BODY><P>How do I let my null values appear as zero?</P></BODY></HTML> Mon, 27 May 2013 14:09:45 GMT https://community.qlik.com/t5/QlikView/Null-values-as-zero/m-p/411347#M153161 jewseppie 2013-05-27T14:09:45Z Re: Null values as zero https://community.qlik.com/t5/QlikView/Null-values-as-zero/m-p/411348#M153162 <HTML><HEAD></HEAD><BODY><P>In pivot tables and straight charts you can set the Null Symbol to a 0 on the Presentation tab of the properties window. You can also replace nulls with 0's in the script by adding these two lines at the top of the script:</P><P></P><P>NullAsValue *;</P><P>set NullValue=0;</P></BODY></HTML> Mon, 27 May 2013 14:11:32 GMT https://community.qlik.com/t5/QlikView/Null-values-as-zero/m-p/411348#M153162 Gysbert_Wassenaar 2013-05-27T14:11:32Z