topic Re: Replace Null Value with Zero in App Development https://community.qlik.com/t5/App-Development/Replace-Null-Value-with-Zero/m-p/1718627#M54590 <P>Try this.</P><LI-CODE lang="markup">RangeSum(FieldName,0) As FieldName</LI-CODE> Sun, 14 Jun 2020 17:40:55 GMT Saravanan_Desingh 2020-06-14T17:40:55Z Replace Null Value with Zero https://community.qlik.com/t5/App-Development/Replace-Null-Value-with-Zero/m-p/1704204#M53986 <P>Hi,</P><P>I have tried to replace null value to zero. But unsuccessful. You can find out the expression - I used all possible function / technique.</P><P>I am attaching the qvf, If anyone can help me on this, Please help.</P><P>Regards,</P><P>AK</P> Mon, 20 Dec 2021 21:08:46 GMT https://community.qlik.com/t5/App-Development/Replace-Null-Value-with-Zero/m-p/1704204#M53986 sona_sa 2021-12-20T21:08:46Z Re: Replace Null Value with Zero https://community.qlik.com/t5/App-Development/Replace-Null-Value-with-Zero/m-p/1704419#M54003 <P>Hello,</P><P>add in the script, in the load instruction</P><P><EM>if (isnull(FieldName)),0,FieldName) as&nbsp;FieldName,</EM></P><P>&nbsp;</P> Fri, 22 May 2020 13:52:56 GMT https://community.qlik.com/t5/App-Development/Replace-Null-Value-with-Zero/m-p/1704419#M54003 jmartineze 2020-05-22T13:52:56Z Re: Replace Null Value with Zero https://community.qlik.com/t5/App-Development/Replace-Null-Value-with-Zero/m-p/1718627#M54590 <P>Try this.</P><LI-CODE lang="markup">RangeSum(FieldName,0) As FieldName</LI-CODE> Sun, 14 Jun 2020 17:40:55 GMT https://community.qlik.com/t5/App-Development/Replace-Null-Value-with-Zero/m-p/1718627#M54590 Saravanan_Desingh 2020-06-14T17:40:55Z