https://community.qlik.com/t5/QlikView/Unable-to-replace-null-values-with-NA/m-p/1754905#M455384 <P>Here are some links that may be of use:</P><P><A href="https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/Scripting/ScriptRegularStatements/NullAsValue.htm" target="_blank">https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/Scripting/ScriptRegularStatements/NullAsValue.htm</A></P><P><A href="https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/Scripting/ValueHandlingVariables/NullDisplay.htm" target="_blank">https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/Scripting/ValueHandlingVariables/NullDisplay.htm</A></P><P><A href="https://community.qlik.com/t5/Qlik-Design-Blog/NULL-The-Invisible-Nothing/ba-p/1467674" target="_blank">https://community.qlik.com/t5/Qlik-Design-Blog/NULL-The-Invisible-Nothing/ba-p/1467674</A></P><P><A href="https://community.qlik.com/t5/Qlik-Design-Blog/Finding-NULL/ba-p/1474279" target="_blank">https://community.qlik.com/t5/Qlik-Design-Blog/Finding-NULL/ba-p/1474279</A></P><P><A href="https://community.qlik.com/t5/Qlik-Design-Blog/Replacing-Null-Values-in-Multiple-Fields/ba-p/1470988" target="_blank">https://community.qlik.com/t5/Qlik-Design-Blog/Replacing-Null-Values-in-Multiple-Fields/ba-p/1470988</A></P><P>There is also ability to change directly in some chart types, see Help below for example:</P><P><A href="https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/Ajax/WebView_StraightTable.htm#anchor-3" target="_blank">https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/Ajax/WebView_StraightTable.htm#anchor-3</A></P><P>Regards,<BR />Brett</P> Thu, 22 Oct 2020 11:30:51 GMT Brett_Bleess 2020-10-22T11:30:51Z https://community.qlik.com/t5/QlikView/Unable-to-replace-null-values-with-NA/m-p/1748698#M455379 <P>Hello All,</P><P>im unable to replace null values with NA, i have tried with multiple function its not working for me.</P><P>Kindly could someone help me.</P><P>&nbsp;</P><P>if(Len(Trim(Value))=0 or Isnull(Value),'NA',</P><P>if(Type= 'MON',Num(MaxString({&lt;MonthYear=,MonthYear={"$(=date(MonthYear-10,'MMM YY'))"}&gt;}Value),'$###,###.00')&amp;'',<BR />if(Type= 'PCT',Num(MaxString({&lt;MonthYear=,MonthYear={"$(=date(MonthYear-10,'MMM YY'))"}&gt;}Value)*100,'##.00%'&amp;' ')&amp;'',<BR />if(Type= 'QTY',Num(MaxString({&lt;MonthYear=,MonthYear={"$(=date(MonthYear-10,'MMM YY'))"}&gt;}Value),',###,###.')))))</P><P>&nbsp;</P><P>Thanks &amp; Regards,</P><P>NR</P> Thu, 01 Oct 2020 05:54:52 GMT https://community.qlik.com/t5/QlikView/Unable-to-replace-null-values-with-NA/m-p/1748698#M455379 NavinReddy 2020-10-01T05:54:52Z https://community.qlik.com/t5/QlikView/Unable-to-replace-null-values-with-NA/m-p/1748703#M455380 <P>Hi&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/29340">@NavinReddy</a>&nbsp;</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="mayuringale25_0-1601533893673.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/41522i5768250CD1FE81FE/image-size/medium?v=v2&amp;px=400" role="button" title="mayuringale25_0-1601533893673.png" alt="mayuringale25_0-1601533893673.png" /></span></P><P>&nbsp;</P><P>Please find attatched qvf&nbsp;</P> Thu, 01 Oct 2020 06:32:18 GMT https://community.qlik.com/t5/QlikView/Unable-to-replace-null-values-with-NA/m-p/1748703#M455380 mayuringale25 2020-10-01T06:32:18Z https://community.qlik.com/t5/QlikView/Unable-to-replace-null-values-with-NA/m-p/1748706#M455381 <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/11786">@mayuringale25</a>&nbsp; Thanks for your reply&nbsp;</P><P>im unable to open qlikview application, please suggest me</P><P>&nbsp;</P> Thu, 01 Oct 2020 06:39:55 GMT https://community.qlik.com/t5/QlikView/Unable-to-replace-null-values-with-NA/m-p/1748706#M455381 NavinReddy 2020-10-01T06:39:55Z https://community.qlik.com/t5/QlikView/Unable-to-replace-null-values-with-NA/m-p/1751410#M455382 <P>hi&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/29340">@NavinReddy</a>&nbsp;</P><P>The qvf is qlik sense file.</P> Mon, 12 Oct 2020 06:11:00 GMT https://community.qlik.com/t5/QlikView/Unable-to-replace-null-values-with-NA/m-p/1751410#M455382 mayuringale25 2020-10-12T06:11:00Z https://community.qlik.com/t5/QlikView/Unable-to-replace-null-values-with-NA/m-p/1751484#M455383 <P>Hi Navin,</P><P>Convert the null value with 'NA' in script. and use in front end.</P><P><SPAN>if(Len(Trim(Value))=0 or Isnull(Value),'NA', Value) as Value<BR /><BR /></SPAN></P><P><SPAN>Hope it helps</SPAN></P> Mon, 12 Oct 2020 09:41:01 GMT https://community.qlik.com/t5/QlikView/Unable-to-replace-null-values-with-NA/m-p/1751484#M455383 MayilVahanan 2020-10-12T09:41:01Z https://community.qlik.com/t5/QlikView/Unable-to-replace-null-values-with-NA/m-p/1754905#M455384 <P>Here are some links that may be of use:</P><P><A href="https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/Scripting/ScriptRegularStatements/NullAsValue.htm" target="_blank">https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/Scripting/ScriptRegularStatements/NullAsValue.htm</A></P><P><A href="https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/Scripting/ValueHandlingVariables/NullDisplay.htm" target="_blank">https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/Scripting/ValueHandlingVariables/NullDisplay.htm</A></P><P><A href="https://community.qlik.com/t5/Qlik-Design-Blog/NULL-The-Invisible-Nothing/ba-p/1467674" target="_blank">https://community.qlik.com/t5/Qlik-Design-Blog/NULL-The-Invisible-Nothing/ba-p/1467674</A></P><P><A href="https://community.qlik.com/t5/Qlik-Design-Blog/Finding-NULL/ba-p/1474279" target="_blank">https://community.qlik.com/t5/Qlik-Design-Blog/Finding-NULL/ba-p/1474279</A></P><P><A href="https://community.qlik.com/t5/Qlik-Design-Blog/Replacing-Null-Values-in-Multiple-Fields/ba-p/1470988" target="_blank">https://community.qlik.com/t5/Qlik-Design-Blog/Replacing-Null-Values-in-Multiple-Fields/ba-p/1470988</A></P><P>There is also ability to change directly in some chart types, see Help below for example:</P><P><A href="https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/Ajax/WebView_StraightTable.htm#anchor-3" target="_blank">https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/Ajax/WebView_StraightTable.htm#anchor-3</A></P><P>Regards,<BR />Brett</P> Thu, 22 Oct 2020 11:30:51 GMT https://community.qlik.com/t5/QlikView/Unable-to-replace-null-values-with-NA/m-p/1754905#M455384 Brett_Bleess 2020-10-22T11:30:51Z https://community.qlik.com/t5/QlikView/Unable-to-replace-null-values-with-NA/m-p/1754910#M455385 <P><BR />can you help me in the pivot table.<BR />I want to hide the rows where column 2 = 0.<BR />how to do it quickly?</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="1.png" style="width: 541px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/42801iB949D53D2F646E53/image-size/large?v=v2&amp;px=999" role="button" title="1.png" alt="1.png" /></span></P> Thu, 22 Oct 2020 11:37:16 GMT https://community.qlik.com/t5/QlikView/Unable-to-replace-null-values-with-NA/m-p/1754910#M455385 Janaszek 2020-10-22T11:37:16Z https://community.qlik.com/t5/QlikView/Unable-to-replace-null-values-with-NA/m-p/1754911#M455386 <P>I want to hide the rows where column 2 &gt; 0.</P> Thu, 22 Oct 2020 11:38:12 GMT https://community.qlik.com/t5/QlikView/Unable-to-replace-null-values-with-NA/m-p/1754911#M455386 Janaszek 2020-10-22T11:38:12Z