Please help on to get previous 6 months data

[#1]

Hi Friends,QlikView Experts please help on issue i am facing.we are storing data in qvd for 1 year separately

2012-2013 --->1 QVD

2013-2014---->1 QVD

.....

Suppose Let say  March-2014 current date i need to check 2014 and 2013 QVD to get past 6 months from current i.e.,oct-13,nov-13,dec-13,jan-14,feb-14,mar-14

To see past 6 months of data from present date rolling period of 6 months

Can any one help in writing loop to pick dynamically past 6 months of data in App.

suppose

[Gysbert_Wassenaar]

Try something like

LOAD * FROM *.qvd (qvd)

WHERE MyDateField <= num(addmonths(today(),-6));