Capturing historical monthly snapshots with QVD's

[#1]

Hi guys. I have an interesting problem I'm trying to solve. I've got a data table that I would like to be able to show month-over-month changes. Is there a good way to do this using QVD's?

So here's my logic. I have the QlikView publisher reloading the QVW once a day. If it's the first of the month, I want it to store a snapshot of a table to a new QVD with a date stamp. So something like "Data-03-2010.QVD". Then, every day when it loads the QVW, I want it to pull in all QVD's that exist in that directory and combine them all together with an effective date field that has 03-2010 and so on. So then, I'll have multiple snapshots of the data table with an effective date so I can compare it month-over-month. Does this make sense? How would I implement this?

Thanks for your help!

Eric

[sjenkins]

Did you ever figure this out? I have exact same requirement.

Thanks,

Steve

[#3]

I suggest having a look at the following code:

For each QvdFile in filelist ('$(QvdLogisticsFolder)\alltrends*.qvd')

trends:

LOAD

BKNG_MNTH,

SOS_3M_ID

FROM $(QvdFile) (qvd);

NEXT QvdFile;

Let me know if that helps.

Dion Verbeke

Lead Business Analyst