Rolling12Months - with Quarter as Date

[h2k18]

Hi,

I have dataset with a field Period which only contains YearQuarter information. The ask is to develop rolling 12 Months based on the YearQuarter and ObjectID selected by the user. I have attached the raw data as well as Qlik Sense file. 

Thanks,
H

[Lauri]

Follow the methodology described here to create an as-of table:

https://community.qlik.com/t5/Qlik-Design-Blog/The-As-Of-Table/ba-p/1466130

Let me know if that makes sense.