Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2014-05-27 05:11 PM

Store in multiple QVD depending on date

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

952 Views
0 Likes
1 Reply
Peter_Cammaert
Partner - Champion III
Partner - Champion III
‎2014-05-27 07:59 PM

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

577 Views
0 Likes