Discussion Board for collaboration related to Creating Analytics for QlikView.
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):
Can someone help me.
May be use the As-Of Table method here: The As-Of Table