topic Moving Month Average in QlikView https://community.qlik.com/t5/QlikView/Moving-Month-Average/m-p/1043003#M940719 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P>i Need to find moving month average for latest 3 months,but my problem is i am using pivot table with 3 dimensions including monthyear i need to add average and deviation at the end ,please help me to achieve this</P><P></P><P>please find the sample requirement snapshot</P><P></P><P></P><P></P><P>Regards,</P><P>Shruthi</P></BODY></HTML> Wed, 03 Feb 2016 16:07:54 GMT shruthibk 2016-02-03T16:07:54Z Moving Month Average https://community.qlik.com/t5/QlikView/Moving-Month-Average/m-p/1043003#M940719 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P>i Need to find moving month average for latest 3 months,but my problem is i am using pivot table with 3 dimensions including monthyear i need to add average and deviation at the end ,please help me to achieve this</P><P></P><P>please find the sample requirement snapshot</P><P></P><P></P><P></P><P>Regards,</P><P>Shruthi</P></BODY></HTML> Wed, 03 Feb 2016 16:07:54 GMT https://community.qlik.com/t5/QlikView/Moving-Month-Average/m-p/1043003#M940719 shruthibk 2016-02-03T16:07:54Z Re: Moving Month Average https://community.qlik.com/t5/QlikView/Moving-Month-Average/m-p/1043004#M940720 <HTML><HEAD></HEAD><BODY><P>See this document: <A href="https://community.qlik.com/docs/DOC-4252">Calculating rolling n-period totals, averages or other aggregations</A></P><P>Or this blog post: <A href="https://community.qlik.com/qlik-blogpost/4531">The As-Of Table</A></P></BODY></HTML> Wed, 03 Feb 2016 18:30:19 GMT https://community.qlik.com/t5/QlikView/Moving-Month-Average/m-p/1043004#M940720 Gysbert_Wassenaar 2016-02-03T18:30:19Z Re: Moving Month Average https://community.qlik.com/t5/QlikView/Moving-Month-Average/m-p/1043005#M940721 <HTML><HEAD></HEAD><BODY><P>hi how can i add last 2 expressions as i have month as dimension </P></BODY></HTML> Thu, 04 Feb 2016 12:48:21 GMT https://community.qlik.com/t5/QlikView/Moving-Month-Average/m-p/1043005#M940721 shruthibk 2016-02-04T12:48:21Z Re: Moving Month Average https://community.qlik.com/t5/QlikView/Moving-Month-Average/m-p/1043006#M940722 <HTML><HEAD></HEAD><BODY><P>Open the charts properties window, go to the Expressions tab and press the Add button to add a new expression.</P></BODY></HTML> Thu, 04 Feb 2016 17:49:00 GMT https://community.qlik.com/t5/QlikView/Moving-Month-Average/m-p/1043006#M940722 Gysbert_Wassenaar 2016-02-04T17:49:00Z