Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
h2k18
Contributor II
Contributor II

Rolling12Months - with Quarter as Date

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

Labels (1)
1 Reply
Lauri
Specialist
Specialist

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.