Discussion Board for collaboration related to QlikView App Development.
I have a requirement like, have to store data in QVD's by monthly with incremental load. How to achieve this?
WHERE MonthName(DateFieldName) = MonthName(Today());
LET vCurrentMonth = MonthName(Today());
STORE Data INTO [$(vCurrentMonth).qvd];
Like this create qvd for every month.
View solution in original post
Download the delta load (incremental load) template from Rob Wunderlich's QV cookbook site:
It does a very good job in explaining the principles of an incremental load (see the script section of the QVW).
Hope this helps,
check this links for more information
Create Monthly QVD's
Check this link
storing data into qvd in monthly basis
Loading Multiple QVD files