Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

shaunsuperbalis
New Contributor

Rolling 12 months Calc

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

5 Replies
MVP
MVP

Re: Rolling 12 months Calc

ecolomer
Honored Contributor II

Re: Rolling 12 months Calc

See this example:

Arjunarao
Honored Contributor II

Re: Rolling 12 months Calc

Hi,

please check this thread.

Set Analysis for Rolling Periods

shaunsuperbalis
New Contributor

Re: Rolling 12 months Calc

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!

Highlighted
shaunsuperbalis
New Contributor

Re: Rolling 12 months Calc

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?