Hi Friends please help on this stuck to generate separate QVD for each Year and to get 12 months of data from current date to rolling of 12 months,
Have written below script [Account Period] column Associates to Monthstart and Monthend
Monthstart
6/1/2013
7/1/2013
8/1/2013
9/1/2013...........12/1/2014
Monthend
6/30/2013
7/31/2013
8/31/2013
9/30/2013.........12/31/2014
temp:
load max([Monthstart_Sales]) as period Resident Sales;
let vperiodcheck=peek('period',0,'temp');
let vlastyear=year(today())-1;
let vCurrentyear=today();
If num(month($(vperiodcheck)))=1
store Sales into Sales_$(vlastyear).qvd(qvd);
ELSEIF
store Sales into Sales_Previous_$(vcurrentyear).qvd(qvd);
ENDIF;
if(num(month($(vperiodcheck)))=6)
