Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

caccio88
New Contributor III

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

Tags (1)
1 Solution

Accepted Solutions
MVP
MVP

Re: Calculate the value of the following 3 months per month

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

3 Replies
MVP
MVP

Re: Calculate the value of the following 3 months per month

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
New Contributor III

Re: Calculate the value of the following 3 months per month

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

MVP
MVP

Re: Calculate the value of the following 3 months per month

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

Community Browser