Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

mrainey18
Contributor

Add Data to QVD

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?

8 Replies
kkkumar82
Valued Contributor III

Re: Add Data to QVD

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

passionate
Valued Contributor

Re: Add Data to QVD

Why are you trying to Concatenating Master calendar data into QVD.

Do you have a huge date range?

mrainey18
Contributor

Re: Add Data to QVD

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.

mrainey18
Contributor

Re: Add Data to QVD

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.

Re: Add Data to QVD

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())

mrainey18
Contributor

Re: Add Data to QVD

I could but this isn't the only use case I have to use a dynamically created inline table.

Re: Add Data to QVD

Why concatenate with past years, why not just generate all the days you need every time?

-Rob

mrainey18
Contributor

Re: Add Data to QVD

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.