topic Creating a null value in load script in QlikView https://community.qlik.com/t5/QlikView/Creating-a-null-value-in-load-script/m-p/757453#M664069 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>How can I create a null value in the load script? I am currently trying something like the following:</P><P></P><P style="padding-left: 30px;">LOAD</P><P style="padding-left: 30px;"></P><P style="padding-left: 30px;">'' as %SalesRegion</P><P style="padding-left: 30px;"></P><P style="padding-left: 30px;">from ...</P><P></P><P>However, this seems to be keeping these values separate from nulls loaded elsewhere in the script. </P><P></P><P>Ideas?</P><P></P><P>Thanks,</P><P>Mel</P></BODY></HTML> Thu, 08 Jan 2015 21:19:41 GMT 2015-01-08T21:19:41Z Creating a null value in load script https://community.qlik.com/t5/QlikView/Creating-a-null-value-in-load-script/m-p/757453#M664069 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>How can I create a null value in the load script? I am currently trying something like the following:</P><P></P><P style="padding-left: 30px;">LOAD</P><P style="padding-left: 30px;"></P><P style="padding-left: 30px;">'' as %SalesRegion</P><P style="padding-left: 30px;"></P><P style="padding-left: 30px;">from ...</P><P></P><P>However, this seems to be keeping these values separate from nulls loaded elsewhere in the script. </P><P></P><P>Ideas?</P><P></P><P>Thanks,</P><P>Mel</P></BODY></HTML> Thu, 08 Jan 2015 21:19:41 GMT https://community.qlik.com/t5/QlikView/Creating-a-null-value-in-load-script/m-p/757453#M664069 2015-01-08T21:19:41Z Re: Creating a null value in load script https://community.qlik.com/t5/QlikView/Creating-a-null-value-in-load-script/m-p/757454#M664070 <HTML><HEAD></HEAD><BODY><P>load</P><P>....</P><P>null() as %SalesRegion,</P><P>....</P><P>from</P><P></P><P>Regards</P></BODY></HTML> Thu, 08 Jan 2015 21:21:24 GMT https://community.qlik.com/t5/QlikView/Creating-a-null-value-in-load-script/m-p/757454#M664070 martinpohl 2015-01-08T21:21:24Z