How to show rolling 13 periods for a variety of field selections
I have been trying to figure out a calculation in qlikview that is somewhat complex in Excel using SUMIF or SUMPRODUCT. I am calculating the Average Unit Volume for the Rolling 13 Periods. So far I have only been successful with a calculation for one period at a time, but I'd like to display the rolling 13P for the last 13 periods in a table manner. I could create 13 boxes and have each of them calculate AUV for each period, but I was hoping there is an easier way of doing it in a table.
This is a nested aggregation that works that calculates the AUV for Rolling 13P for current period only or for only one given period.
Thank you @qlik learn. The solution you have provided does not seem to calculate the rolling sum of previous 13 periods. What it does is just shows the periodic average - which is correct - but not quite what I am looking for.
Thanks - yes, I have been referred to this very helpful document many times. Does the AsOfTable work on non-time dimension...like P1, P2, etc. instead of months and years? I tried it and it doesn't seem to pick it up.