topic Re: Rolling 3 months in Rolling 6 months in QlikView https://community.qlik.com/t5/QlikView/Rolling-3-months-in-Rolling-6-months/m-p/1158023#M377613 <HTML><HEAD></HEAD><BODY><P>did you check this?</P><P></P><P><A href="https://community.qlik.com/docs/DOC-4252">Calculating rolling n-period totals, averages or other aggregations</A></P><P></P><P><A href="https://community.qlik.com/docs/DOC-8574">Rolling Month</A></P></BODY></HTML> Wed, 07 Sep 2016 11:25:17 GMT Anonymous 2016-09-07T11:25:17Z Rolling 3 months in Rolling 6 months https://community.qlik.com/t5/QlikView/Rolling-3-months-in-Rolling-6-months/m-p/1158022#M377612 <HTML><HEAD></HEAD><BODY><P>Dear Experts,</P><P></P><P></P><P></P><P>I have an issue where I need to calculate rolling 3 months inside rolling 6 months.</P><P></P><P></P><P> I have used 'As of' table to calculate Rolling 6 months but unable to calculate Rolling 3 months in it.</P><P></P><P></P><P>For eg in the application For Aug 2016 for selection year 2016 = Sum(Rolling 6 months ie Mar to Aug) + (Rolling 3 months ie Jun to Aug) = 155449606 is the output required</P><P>ie -104417459 + -51032147.79 = 155449606.79</P><P></P><P></P><P>Similary for July = -117432596.0875 + -65438241.92 =-182870838.0075 is the output required.</P><P></P><P></P><P>Kindly help</P></BODY></HTML> Wed, 07 Sep 2016 11:03:40 GMT https://community.qlik.com/t5/QlikView/Rolling-3-months-in-Rolling-6-months/m-p/1158022#M377612 rahulsud007 2016-09-07T11:03:40Z Re: Rolling 3 months in Rolling 6 months https://community.qlik.com/t5/QlikView/Rolling-3-months-in-Rolling-6-months/m-p/1158023#M377613 <HTML><HEAD></HEAD><BODY><P>did you check this?</P><P></P><P><A href="https://community.qlik.com/docs/DOC-4252">Calculating rolling n-period totals, averages or other aggregations</A></P><P></P><P><A href="https://community.qlik.com/docs/DOC-8574">Rolling Month</A></P></BODY></HTML> Wed, 07 Sep 2016 11:25:17 GMT https://community.qlik.com/t5/QlikView/Rolling-3-months-in-Rolling-6-months/m-p/1158023#M377613 Anonymous 2016-09-07T11:25:17Z Re: Rolling 3 months in Rolling 6 months https://community.qlik.com/t5/QlikView/Rolling-3-months-in-Rolling-6-months/m-p/1158024#M377614 <HTML><HEAD></HEAD><BODY><P>Yes, got As of logic from here.</P></BODY></HTML> Wed, 07 Sep 2016 11:29:04 GMT https://community.qlik.com/t5/QlikView/Rolling-3-months-in-Rolling-6-months/m-p/1158024#M377614 rahulsud007 2016-09-07T11:29:04Z