Store in multiple QVD depending on date

[Anonymous]

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!!!

[Peter_Cammaert]

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