Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

12 Rolling Months on X-as

I have to create a graph with Sales of last 12  months  (June 2106 jback to July 2105) ,   compared with the year before (June 2015 - July 2014).

Data on the graph will have two lines ::

-> one line is the sales of 12 month from now until 12 months back

-> second line is the sales of 13 month ago until 24 months ago.

X-as contains 12 months not 24. (today we are for ex. june 2016):

Jun 2016

May 2016

Apr 2016

Mrt 2016

Feb 2016

Jan 2016

Dec 2015

Nov 2015

Oct 2015

Spt 2015

Aug 2015

July 2015

Can someone help me.

thx

1 Reply

Re: 12 Rolling Months on X-as

May be use the As-Of Table method here: The As-Of Table

Community Browser