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 3 month average for past 6 months


Hi

I need to calculate the rolling 3 month average for a key performance indicator.

1. In the expression, how do I select the current month and months -1, ... -6;

2. How do I calculate the rolling avg for these months.

Will appreciate

Fanie

12 Replies
Not applicable
Author

Fanie,

1 approach i know is with island table and if in expression:

Not applicable
Author

and 2'nd with intersection and set analysis

Gysbert_Wassenaar

This document may be of use: Calculating rolling n-period totals, averages or other aggregations


talk is cheap, supply exceeds demand
Not applicable
Author

Dankie Gysbert


Not applicable
Author

Thank you Dariusz

Not applicable
Author

Dariusz do you have an example of intersection and set analysis?

Fanie

Not applicable
Author

Examples are attached above....

Can't you see them?

Not applicable
Author

ohh, i'am sorry, no i can see, that i attached the same twice. give ma a moment

Not applicable
Author

I exchanged set example