Generating missing dates and adding missing data for these dates

[Anonymous]

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

[vinieme12]

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