Cursor of date and store into QVD's

[tchovanec]

I am trying to load data in 5 year increments into a qvd. Is there a way to cursor over my table and store data into qvd's in 5 year increments. So, 1 qvd would hold 2012-2007 data, then the next 2006-2001 and so on. I appreciate any assistance. Thank you

[tanelry]

It looks like one-time job, so instead of writing new script you could do it manually,

just exporting the qvd-s from QV document without full script run.

1) make sure you have unchecked "Save Before Reload" under User Preferences > Save

(we don't want to save any changes here)

2) clear all selections, select years 2012-2007 and commit File > reduce data > keep possible values

3) open script and in the very beginning of script add two lines:

STORE TableName into TableName20072012.qvd (qvd);

EXIT Script;

4) run File > partial reload. It will create your qvd.

5) Close QV document without saving. Reopen QV document and repeat with other years.