topic Re: Null value go to Zero in QlikView https://community.qlik.com/t5/QlikView/Null-value-go-to-Zero/m-p/1082264#M926204 <HTML><HEAD></HEAD><BODY><P>Hi Sagara,</P><P></P><P>If you got the solution, please close the thread by marking correct answer. If not, let us know. </P></BODY></HTML> Tue, 29 Mar 2016 04:49:18 GMT tamilarasu 2016-03-29T04:49:18Z Null value go to Zero https://community.qlik.com/t5/QlikView/Null-value-go-to-Zero/m-p/1082260#M926200 <HTML><HEAD></HEAD><BODY><P>Dear All</P><P>I have a expression and in that include a null value. I want to in that null value become a zero. please refer attachment and give a best solution.</P><P></P><P>thanks</P><P></P><P>sagara</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Null-value-go-to-Zero/m-p/1082260#M926200 sagaraperera 2020-11-25T16:16:04Z Re: Null value go to Zero https://community.qlik.com/t5/QlikView/Null-value-go-to-Zero/m-p/1082261#M926201 <HTML><HEAD></HEAD><BODY><P><EM>Hi,</EM></P><P></P><P><EM>Go to chart properties - &gt; Presentation tab - &gt; Remove hyphen from Null symbol box and type 0.</EM></P></BODY></HTML> Tue, 29 Mar 2016 04:15:36 GMT https://community.qlik.com/t5/QlikView/Null-value-go-to-Zero/m-p/1082261#M926201 tamilarasu 2016-03-29T04:15:36Z Re: Null value go to Zero https://community.qlik.com/t5/QlikView/Null-value-go-to-Zero/m-p/1082262#M926202 <HTML><HEAD></HEAD><BODY><P>Dear Mr.<SPAN style="text-decoration: underline;">Tamil</SPAN></P><P><SPAN style="text-decoration: underline;">Thanks your response </SPAN></P><P></P><P>sagara</P></BODY></HTML> Tue, 29 Mar 2016 04:35:57 GMT https://community.qlik.com/t5/QlikView/Null-value-go-to-Zero/m-p/1082262#M926202 sagaraperera 2016-03-29T04:35:57Z Re: Null value go to Zero https://community.qlik.com/t5/QlikView/Null-value-go-to-Zero/m-p/1082263#M926203 <HTML><HEAD></HEAD><BODY><P>in script</P><P></P><P>set nullvalue='0';</P></BODY></HTML> Tue, 29 Mar 2016 04:38:38 GMT https://community.qlik.com/t5/QlikView/Null-value-go-to-Zero/m-p/1082263#M926203 Chanty4u 2016-03-29T04:38:38Z Re: Null value go to Zero https://community.qlik.com/t5/QlikView/Null-value-go-to-Zero/m-p/1082264#M926204 <HTML><HEAD></HEAD><BODY><P>Hi Sagara,</P><P></P><P>If you got the solution, please close the thread by marking correct answer. If not, let us know. </P></BODY></HTML> Tue, 29 Mar 2016 04:49:18 GMT https://community.qlik.com/t5/QlikView/Null-value-go-to-Zero/m-p/1082264#M926204 tamilarasu 2016-03-29T04:49:18Z Re: Null value go to Zero https://community.qlik.com/t5/QlikView/Null-value-go-to-Zero/m-p/1082265#M926205 <HTML><HEAD></HEAD><BODY><P>If you need a genuine zero value from a null, use Alt(), eg</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; Alt(<EM>&lt;your expression&gt;</EM>, 0)</P></BODY></HTML> Tue, 29 Mar 2016 05:09:09 GMT https://community.qlik.com/t5/QlikView/Null-value-go-to-Zero/m-p/1082265#M926205 jonathandienst 2016-03-29T05:09:09Z Re: Null value go to Zero https://community.qlik.com/t5/QlikView/Null-value-go-to-Zero/m-p/1082266#M926206 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>If you want to make this change in excel sheet,</P><P></P><P>than<STRONG> Ctrl+f ----&gt;</STRONG></P><P><STRONG>Find What:&nbsp;&nbsp;&nbsp; -</STRONG></P><P><STRONG>Replace with:&nbsp;&nbsp;&nbsp; 0</STRONG></P></BODY></HTML> Tue, 29 Mar 2016 05:44:44 GMT https://community.qlik.com/t5/QlikView/Null-value-go-to-Zero/m-p/1082266#M926206 tyagishaila 2016-03-29T05:44:44Z Re: Null value go to Zero https://community.qlik.com/t5/QlikView/Null-value-go-to-Zero/m-p/1082267#M926207 <HTML><HEAD></HEAD><BODY><P>check this link: <A href="https://community.qlik.com/thread/211062">How to replace null for 0 value in script</A></P></BODY></HTML> Tue, 29 Mar 2016 06:45:26 GMT https://community.qlik.com/t5/QlikView/Null-value-go-to-Zero/m-p/1082267#M926207 amayuresh 2016-03-29T06:45:26Z