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: 
caccio88
Creator II
Creator II

Calculate the value of the following 3 months per month

Hi everyone,

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.

Filiberto

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Potentially yes, you probably would just need to use below() instead of above() inter record chart function.

View solution in original post

3 Replies
swuehl
MVP
MVP

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 Month
Resident SalesData
while IterNo() <= 3;

caccio88
Creator II
Creator II
Author

Do u think that it's possible using even the rangesum-aggr combination? swuehl

swuehl
MVP
MVP

Potentially yes, you probably would just need to use below() instead of above() inter record chart function.