Discussion Board for collaboration on QlikView Layout & Visualizations.
I learned from the great explanation of gwassenaar here in Calculating rolling n-period totals, averages or other aggregations
how i'm ablet to calculate the value per month of the previous 3 months.
But what if I want to calculate the value per month of the following 3 months?
Someone could help me?
Here attached my example.
Thank u all.
Go to Solution.
Potentially yes, you probably would just need to use below() instead of above() inter record chart function.
There shouldn't be a fundamental difference if you want to look ahead in time, maybe just adapt the AsOfMonth Month field calculation (taken from the original doc):
AsOfMonth:load Month as Month_AsOf,Month + (IterNo()-1) as MonthResident SalesDatawhile IterNo() <= 3;
Do u think that it's possible using even the rangesum-aggr combination? swuehl