Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
Showing results for 
Search instead for 
Did you mean: 

Calculating rolling 12 Month problem

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?


2 Replies

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

talk is cheap, supply exceeds demand

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).