topic Re: Calculating rolling 12 Month problem in QlikView

Calculating rolling 12 Month problem

paolojolly — Thu, 25 Sep 2014 14:53:12 GMT

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 — Fri, 26 Sep 2014 11:37:41 GMT

rubenmarin — Fri, 26 Sep 2014 11:52:41 GMT

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