Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Why are you trying to Concatenating Master calendar data into QVD.
Do you have a huge date range?
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.
Using QVD files for incremental load ‒ Qlik Sense
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())
I could but this isn't the only use case I have to use a dynamically created inline table.
Why concatenate with past years, why not just generate all the days you need every time?
-Rob
I can do either or. It doesn't matter once I have the generated inline table. The concatenate is just an extra step that I choose to skip if I wanted.