Calculating rolling 12 Month problem

[paolojolly]

Hi I'm new in Qlikview and I need help to create a document in which I select a month using a variable and in

a table I need to get the sum of the quantity of the previous 12 months.

For example if I select month 8 i need to have a table like this

I tried two different ways, one works but is slow, another(using rangesum and above ) is not working properly

I attach a sample document

Can someone help me?

thanks

[Gysbert_Wassenaar]

See this document: Calculating rolling n-period totals, averages or other aggregations

[rubenmarin]

It's difficult because you have no data in month 7 for 2013 and 2014. Creating data for those months will solve the problem in the first column.

You can calculate the accumulation for each period in script if other requirements allow it (mostly filter selections).