Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

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

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

uno.png

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

2 Replies
Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand
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).