Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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