Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
Please can any one help on this facing hard days
Can any one has solution please share on this