Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Rolling 12 in all periods Chart

I have a line chart with year quarter as a dimension and I want to show rolling 12 in each quarter.

If I use aggr and rangesum the last quarter will be right.

How can I do this?

I don´t have the as of calendar.



1 Reply

Re: Rolling 12 in all periods Chart

If you use quarter-year as dimension you'll need an asof table. See this document: Calculating rolling n-period totals, averages or other aggregations

talk is cheap, supply exceeds demand
Community Browser