https://community.qlik.com/t5/QlikView/To-Show-Rolling-3-Months-Data/m-p/1811590#M1212672 <P>Hi, one possible solution may be using an as-of calendar:&nbsp;<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> Sun, 30 May 2021 07:19:25 GMT rubenmarin 2021-05-30T07:19:25Z https://community.qlik.com/t5/QlikView/To-Show-Rolling-3-Months-Data/m-p/1811381#M1212659 <P>Hi All,</P><P>I want to show rolling 3 months sales in straight table based on month selection.</P><P>For Eg. If I select June from filter then data should show June, May, April months sales value</P><P>I have only year and month field in the data. I don't have date field.</P><P>Please help to achieve this task.</P><P>Thanks</P> Fri, 28 May 2021 13:19:50 GMT https://community.qlik.com/t5/QlikView/To-Show-Rolling-3-Months-Data/m-p/1811381#M1212659 sunitha_chellaiah 2021-05-28T13:19:50Z https://community.qlik.com/t5/QlikView/To-Show-Rolling-3-Months-Data/m-p/1811590#M1212672 <P>Hi, one possible solution may be using an as-of calendar:&nbsp;<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> Sun, 30 May 2021 07:19:25 GMT https://community.qlik.com/t5/QlikView/To-Show-Rolling-3-Months-Data/m-p/1811590#M1212672 rubenmarin 2021-05-30T07:19:25Z