Rolling 12 months Calc

[Anonymous]

Hello

I've been having difficulty trying to write an expression that will look at the month at hand, and the 12 months before when performing a calculation.

I know about the ABOVE function, but it isn't behaving as we expect because the sheet is designed in a way that the user needs to select 3/4 months. I have tried using set analysis, but haven't succeeded.

Can anyone point me in the right direction / advise as to how I can achieve this?

Thanks very much in advance

[MK_QSL]

Have you tried this?

Calculating rolling n-period totals, averages or other aggregations

[ecolomer]

See this example:

[qlikviewwizard]

Hi,

please check this thread.

Set Analysis for Rolling Periods

[Anonymous]

Hi Enrique

Thank you for your reply. The user is going to select 3/4 months. For example, February, March and April for one year and I'd like to see 3 different values for each month. Currently, how your expression functions, it will only show the result for the largest selected YEARMONTH.

Any suggestions to make this a little more flexible?

Thanks in advance!

[Anonymous]

Hi Arjun

Thanks for this. I am still a little bit stuck.

Essentially, the straight table will display the 3 months the user has selected. The dimension will be month.

Each of the months displayed will need to contain data from previous months (up to 12 months back).

Is this possible?