I am trying to create a master calendar QVD. This will have a line for everyday in the year.
My goal is to run this once a year and have Qlik create the data and concatenate it with the past years.
Is that possible?
Yes ofcourse, use the logic of "Incremental load" for insert where you will be loading the qvd + your new data, both of them will be concatenated after loading and just create a new qvd with the same name which will replace the old one
containing old + new records
Share some sample so that we can explain the process
We have been having issues with AutoCalendar. We are going to try this and see if it works better. I just wanted to make sure it was possible.
Its not a huge date range. We have some weird formatting requirements from our end user that throws off the AutoCalendar.
This is great but only solves half the problem. I do not want to load new data from a DB or Excel file. I want to create it in a Qlik script.
How should I do that?
What I'm thinking of doing is using a do while loop to increment a variable by 1. Inside the loop I will do all my formatting and then insert it into an inline table.
The inserting these calculated fields into the inline table is where I'm drawing a blank.
Maybe create a communal Master Calendar for say this and next decade - then when you load it use a where clause to just bring in the date range you want.
e.g. where [Year] <= year(today())