Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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.

Regards

Jenny

1 Reply
Gysbert_Wassenaar

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