topic Re: Rolling 12 months Calc in QlikView

Rolling 12 months Calc

Anonymous — Fri, 25 Sep 2015 14:58:48 GMT

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

Re: Rolling 12 months Calc

MK_QSL — Fri, 25 Sep 2015 14:59:45 GMT

Have you tried this?

Calculating rolling n-period totals, averages or other aggregations

Re: Rolling 12 months Calc

ecolomer — Fri, 25 Sep 2015 21:14:43 GMT

See this example:

Re: Rolling 12 months Calc

qlikviewwizard — Sat, 26 Sep 2015 01:27:02 GMT

Hi,

please check this thread.

Set Analysis for Rolling Periods

Re: Rolling 12 months Calc

Anonymous — Tue, 29 Sep 2015 13:31:50 GMT

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!

Re: Rolling 12 months Calc

Anonymous — Tue, 29 Sep 2015 14:26:48 GMT

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?