Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Qlik Highlights 2020 Giveaway! Watch, reply and have a chance to win a $200 Amazon Gift Card! Watch Video
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Stuck with generate Year wise QVD and Fetch the 12 months of data

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)

2 Replies
Contributor III
Contributor III

Please can any one help on this facing hard days

Contributor III
Contributor III

Can any one has solution please share on this