https://community.qlik.com/t5/QlikView/rolling-months-in-backend/m-p/1672917#M593202 <P>I would recommend you to take a look at HICs blog post about<A href="https://community.qlik.com/t5/Qlik-Design-Blog/The-As-Of-Table/ba-p/1466130" target="_self">&nbsp;The As-Of Table</A> in order to sort you Rolling 3 and 6 months needs.</P> Thu, 06 Feb 2020 12:00:43 GMT Vegar 2020-02-06T12:00:43Z https://community.qlik.com/t5/QlikView/rolling-months-in-backend/m-p/1672912#M593201 <P>Hi All,</P><P>I need to derive a field(period) rolling 3months and rolling 6months in qlik script level because I have to use in front end.</P><P>I've created two tables in the data model(data and master calendar).</P><P><BR />Please help me out in this.</P><P>&nbsp;</P><P>&nbsp;</P> Thu, 06 Feb 2020 11:54:09 GMT https://community.qlik.com/t5/QlikView/rolling-months-in-backend/m-p/1672912#M593201 antonybi 2020-02-06T11:54:09Z https://community.qlik.com/t5/QlikView/rolling-months-in-backend/m-p/1672917#M593202 <P>I would recommend you to take a look at HICs blog post about<A href="https://community.qlik.com/t5/Qlik-Design-Blog/The-As-Of-Table/ba-p/1466130" target="_self">&nbsp;The As-Of Table</A> in order to sort you Rolling 3 and 6 months needs.</P> Thu, 06 Feb 2020 12:00:43 GMT https://community.qlik.com/t5/QlikView/rolling-months-in-backend/m-p/1672917#M593202 Vegar 2020-02-06T12:00:43Z