Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.