https://community.qlik.com/t5/App-Development/Rolling12Months-with-Quarter-as-Date/m-p/1640859#M47770 <P>Follow the methodology described here to create an as-of table:</P><P><A href="https://community.qlik.com/t5/Qlik-Design-Blog/The-As-Of-Table/ba-p/1466130" target="_blank">https://community.qlik.com/t5/Qlik-Design-Blog/The-As-Of-Table/ba-p/1466130</A></P><P>Let me know if that makes sense.</P> Tue, 29 Oct 2019 14:11:20 GMT Lauri 2019-10-29T14:11:20Z https://community.qlik.com/t5/App-Development/Rolling12Months-with-Quarter-as-Date/m-p/1639702#M47680 <P>Hi,</P><P>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.&nbsp;</P><P>Thanks,<BR />H</P> Sat, 16 Nov 2024 19:48:48 GMT https://community.qlik.com/t5/App-Development/Rolling12Months-with-Quarter-as-Date/m-p/1639702#M47680 h2k18 2024-11-16T19:48:48Z https://community.qlik.com/t5/App-Development/Rolling12Months-with-Quarter-as-Date/m-p/1640859#M47770 <P>Follow the methodology described here to create an as-of table:</P><P><A href="https://community.qlik.com/t5/Qlik-Design-Blog/The-As-Of-Table/ba-p/1466130" target="_blank">https://community.qlik.com/t5/Qlik-Design-Blog/The-As-Of-Table/ba-p/1466130</A></P><P>Let me know if that makes sense.</P> Tue, 29 Oct 2019 14:11:20 GMT https://community.qlik.com/t5/App-Development/Rolling12Months-with-Quarter-as-Date/m-p/1640859#M47770 Lauri 2019-10-29T14:11:20Z