Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
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
sunny_talwar

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