Generating missing dates and adding missing data for these dates

Anonymous — Tue, 18 Apr 2017 06:02:17 GMT

I need to generate dates from 1 Jan 2016 to 31 Jan 2016 as these dates are missing in my current file. For each of these dates I need to create Tickets i.e Id field with '0' or null Values.

So i have referred to this blog Generating Missing Data In QlikView

Details in the system are reported from Nov 2016 till April 2017.

Please find my file attached. I have modified the script to put min an max dates as 1 Jan 2016 to 31 Jan 2016 and joined it with the data file but i am getting dates from 1899 and dates from Jan 2016 are not getting created.

Dates from Nov 2016 till April 2017 appear because these are the dates from which the system has data reported.

Can anybody suggest how i can modify the script to generate dates from 1 Jan 2016 to 31 Jan 2016 with '0' as Ticket number i.e. Id field

Re: Generating missing dates and adding missing data for these dates

vinieme12 — Tue, 18 Apr 2017 08:06:53 GMT

refer this post

How to populate a sparsely populated field

just one change in the end, instead of using Peek() to refer value from previous row, just replace with 0

example;

Rates:

NoConcatenate Load Date,
If( IsNull( Rate ), 0, Rate ) as Rate

topic Generating missing dates and adding missing data for these dates in QlikView

Generating missing dates and adding missing data for these dates

Re: Generating missing dates and adding missing data for these dates