topic Re: Store in multiple QVD depending on date in QlikView

Store in multiple QVD depending on date

Anonymous — Tue, 27 May 2014 21:11:53 GMT

Hi guys,

I have this big table, and I want to split the data by year/month, and make like an incremental load for the new data.

i.e:

TotalSales_201401.qvd

TotalSales_201402.qvd

And daily update the equivalent to TotalSales_201405.qvd (assuming that is the current month).

I don't know what to use, if I need a FOR or what...

Looking forward a soon answer!

Thanks a lot!!!

Re: Store in multiple QVD depending on date

Peter_Cammaert — Tue, 27 May 2014 23:59:40 GMT

Explanations, useful tips and example QlikView documents: Re: How to store the data of a table into Monthly and MonthEnd QVD's?

To perform an incremental STORE, check whether the file for the month you are handling already exists - except for the current month. Store each month only if the file doesn't exist. Then always write out the current month (whether there is an increment or not, it won't take too much time)

Good luck,

Peter