Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

divya_anand
Contributor II

Sum of rolling 12 months based on selection

Hi,

I have attached a sample QVW with simple Year_Month & Sales data. I'm trying to display sum of rolling 12 months values based on current selection. In the attached QVW, when I choose 2018-Oct, It displays the right value but only for 2018-Oct, how do I display last 12 months to the month of selection as shown in the below screenshot?

Thank you. 

RollingSnap.PNG

Labels (2)
4 Replies
Shubham_Deshmukh
Valued Contributor

Re: Sum of rolling 12 months based on selection

divya_anand
Contributor II

Re: Sum of rolling 12 months based on selection

Hi Shubham,

It ain't working, looks like I have to use As-of calendar.
Shubham_Deshmukh
Valued Contributor

Re: Sum of rolling 12 months based on selection

What error u r getting?
divya_anand
Contributor II

Re: Sum of rolling 12 months based on selection

Conceptually, I think As-of is what i need to use and I have implemented as described here. 

The calculation is correct, however, I am unable to restrict the table to display only the rows marked in the below screenshot when Year=2018 & Month=Oct is selected (i.e., rolling 12 months).

I have attached the QVW for reference.

Thank you.

As-of.PNG