topic Replace Null Values for 0 in QlikView https://community.qlik.com/t5/QlikView/Replace-Null-Values-for-0/m-p/1403546#M800794 <HTML><HEAD></HEAD><BODY><P>Hi, I'm loading several excel files with diferente fields. I want to create a condition that replace null values for 0. <BR />I know how to do for a specifc field but in this case the name of field can be variable (more then 100 fields) so i want create a condtion for table. </P><P></P><P>Check Table if null replace to 0.</P><P></P><P>Anyone has idea how to do it? Thanks in advance</P><P></P><P>Regards</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT brunopaulo 2020-11-25T16:16:04Z Replace Null Values for 0 https://community.qlik.com/t5/QlikView/Replace-Null-Values-for-0/m-p/1403546#M800794 <HTML><HEAD></HEAD><BODY><P>Hi, I'm loading several excel files with diferente fields. I want to create a condition that replace null values for 0. <BR />I know how to do for a specifc field but in this case the name of field can be variable (more then 100 fields) so i want create a condtion for table. </P><P></P><P>Check Table if null replace to 0.</P><P></P><P>Anyone has idea how to do it? Thanks in advance</P><P></P><P>Regards</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Replace-Null-Values-for-0/m-p/1403546#M800794 brunopaulo 2020-11-25T16:16:04Z Re: Replace Null Values for 0 https://community.qlik.com/t5/QlikView/Replace-Null-Values-for-0/m-p/1403547#M800795 <HTML><HEAD></HEAD><BODY><P>Hi Bruno,</P><P></P><P>Take a look at null as value.</P><P><A href="http://help.qlik.com/en-US/sense/September2017/Subsystems/Hub/Content/Scripting/ScriptRegularStatements/NullAsValue.htm" title="http://help.qlik.com/en-US/sense/September2017/Subsystems/Hub/Content/Scripting/ScriptRegularStatements/NullAsValue.htm">NullAsValue ‒ Qlik Sense</A></P></BODY></HTML> Thu, 30 Nov 2017 11:52:00 GMT https://community.qlik.com/t5/QlikView/Replace-Null-Values-for-0/m-p/1403547#M800795 Mark_Little 2017-11-30T11:52:00Z Re: Replace Null Values for 0 https://community.qlik.com/t5/QlikView/Replace-Null-Values-for-0/m-p/1403548#M800796 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #0000ff;">Try this code above your load script.</SPAN></P><P></P><P></P><P><SPAN style="color: #0000ff;"><SPAN style="color: #0000ff;">NullAsValue</SPAN><SPAN style="color: #333333;"> *; </SPAN><SPAN style="color: #0000ff;">SET</SPAN><SPAN style="color: #333333;"> NullValue = ‘0’;</SPAN></SPAN></P><P></P><P></P><P><SPAN style="color: #333333;">regards</SPAN></P><P><SPAN style="color: #333333;">tim</SPAN></P></BODY></HTML> Thu, 30 Nov 2017 11:53:01 GMT https://community.qlik.com/t5/QlikView/Replace-Null-Values-for-0/m-p/1403548#M800796 zhadrakas 2017-11-30T11:53:01Z Re: Replace Null Values for 0 https://community.qlik.com/t5/QlikView/Replace-Null-Values-for-0/m-p/1403549#M800797 <HTML><HEAD></HEAD><BODY><P>Didnt work. But this is the way</P></BODY></HTML> Thu, 30 Nov 2017 11:58:00 GMT https://community.qlik.com/t5/QlikView/Replace-Null-Values-for-0/m-p/1403549#M800797 brunopaulo 2017-11-30T11:58:00Z Re: Replace Null Values for 0 https://community.qlik.com/t5/QlikView/Replace-Null-Values-for-0/m-p/1403550#M800798 <HTML><HEAD></HEAD><BODY><P>you can try to add this line. Maybe QlikView dont recognize that the empty cells are real NULL Values.</P><P></P><P><SPAN style="color: #0000ff;">SET</SPAN><SPAN style="color: #000000;"> NullInterpret = ‘’;</SPAN></P><P></P><P><SPAN style="color: #000000;">regards</SPAN></P><P><SPAN style="color: #000000;">tim</SPAN></P></BODY></HTML> Thu, 30 Nov 2017 12:02:15 GMT https://community.qlik.com/t5/QlikView/Replace-Null-Values-for-0/m-p/1403550#M800798 zhadrakas 2017-11-30T12:02:15Z Re: Replace Null Values for 0 https://community.qlik.com/t5/QlikView/Replace-Null-Values-for-0/m-p/1403551#M800799 <HTML><HEAD></HEAD><BODY><P>Thank you, solved it!!!!</P></BODY></HTML> Thu, 30 Nov 2017 12:04:45 GMT https://community.qlik.com/t5/QlikView/Replace-Null-Values-for-0/m-p/1403551#M800799 brunopaulo 2017-11-30T12:04:45Z