topic Re: generate data in load script in QlikView https://community.qlik.com/t5/QlikView/generate-data-in-load-script/m-p/104384#M603881 <HTML><HEAD></HEAD><BODY><P>Have a look here:</P><P> <A href="https://community.qlik.com/docs/DOC-3786">Generating Missing Data In QlikView</A></P><P><A href="https://community.qlik.com/qlik-blogpost/2928">How to populate a sparsely populated field</A></P></BODY></HTML> Fri, 07 Sep 2018 08:36:43 GMT tresB 2018-09-07T08:36:43Z generate data in load script https://community.qlik.com/t5/QlikView/generate-data-in-load-script/m-p/104383#M603880 <HTML><HEAD></HEAD><BODY><P>hi,</P><P>i have the following table (smal sample below) loaded from and excel sheet.</P><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/212932_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P><P></P><P>i need to code it so that whenever someone does not have a value for a date (e.g. mary on 31st aug) then it is assigned zero.</P><P>i.e.&nbsp; i need this:</P><P><IMG alt="" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/212936_pastedImage_1.png" style="max-width: 1200px; max-height: 900px;" /></P><P></P><P>thank you in advance for your assistance.</P><P>have a nice weekend.</P></BODY></HTML> Fri, 07 Sep 2018 08:31:25 GMT https://community.qlik.com/t5/QlikView/generate-data-in-load-script/m-p/104383#M603880 wade12 2018-09-07T08:31:25Z Re: generate data in load script https://community.qlik.com/t5/QlikView/generate-data-in-load-script/m-p/104384#M603881 <HTML><HEAD></HEAD><BODY><P>Have a look here:</P><P> <A href="https://community.qlik.com/docs/DOC-3786">Generating Missing Data In QlikView</A></P><P><A href="https://community.qlik.com/qlik-blogpost/2928">How to populate a sparsely populated field</A></P></BODY></HTML> Fri, 07 Sep 2018 08:36:43 GMT https://community.qlik.com/t5/QlikView/generate-data-in-load-script/m-p/104384#M603881 tresB 2018-09-07T08:36:43Z Re: generate data in load script https://community.qlik.com/t5/QlikView/generate-data-in-load-script/m-p/104385#M603882 <HTML><HEAD></HEAD><BODY><P>thanks tresesco.</P></BODY></HTML> Fri, 07 Sep 2018 08:49:49 GMT https://community.qlik.com/t5/QlikView/generate-data-in-load-script/m-p/104385#M603882 wade12 2018-09-07T08:49:49Z