Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
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
Highlighted
MVP
MVP

Highlighted
Master II
Master II

See this example:

Highlighted
Master II
Master II

Hi,

please check this thread.

Set Analysis for Rolling Periods

Highlighted
Contributor
Contributor

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

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?