topic Re: Re: How to create Last three months rolling average in QlikView https://community.qlik.com/t5/QlikView/How-to-create-Last-three-months-rolling-average/m-p/580676#M215745 <HTML><HEAD></HEAD><BODY><P>I need to create the last three months rolling avg field.</P></BODY></HTML> Mon, 31 Mar 2014 11:53:05 GMT 2014-03-31T11:53:05Z How to create Last three months rolling average https://community.qlik.com/t5/QlikView/How-to-create-Last-three-months-rolling-average/m-p/580673#M215742 <HTML><HEAD></HEAD><BODY><P>I have one requirement, How to calculate the last three months rolling average. How to calculate it.</P><P>I have one Year field and one month field and calculate the every last three months rolling avg. We need to create rolling average is the one more field. How can i do that.</P></BODY></HTML> Mon, 31 Mar 2014 11:39:11 GMT https://community.qlik.com/t5/QlikView/How-to-create-Last-three-months-rolling-average/m-p/580673#M215742 2014-03-31T11:39:11Z Re: How to create Last three months rolling average https://community.qlik.com/t5/QlikView/How-to-create-Last-three-months-rolling-average/m-p/580674#M215743 <HTML><HEAD></HEAD><BODY><P>if possible please attach the sample qvw file.</P><P></P><P>-Nilesh</P></BODY></HTML> Mon, 31 Mar 2014 11:40:50 GMT https://community.qlik.com/t5/QlikView/How-to-create-Last-three-months-rolling-average/m-p/580674#M215743 nilesh_gangurde 2014-03-31T11:40:50Z Re: How to create Last three months rolling average https://community.qlik.com/t5/QlikView/How-to-create-Last-three-months-rolling-average/m-p/580675#M215744 <HTML><HEAD></HEAD><BODY><P><A href="https://community.qlik.com/docs/DOC-4252">Calculating rolling n-period totals, averages or other aggregations</A></P></BODY></HTML> Mon, 31 Mar 2014 11:41:11 GMT https://community.qlik.com/t5/QlikView/How-to-create-Last-three-months-rolling-average/m-p/580675#M215744 MK_QSL 2014-03-31T11:41:11Z Re: Re: How to create Last three months rolling average https://community.qlik.com/t5/QlikView/How-to-create-Last-three-months-rolling-average/m-p/580676#M215745 <HTML><HEAD></HEAD><BODY><P>I need to create the last three months rolling avg field.</P></BODY></HTML> Mon, 31 Mar 2014 11:53:05 GMT https://community.qlik.com/t5/QlikView/How-to-create-Last-three-months-rolling-average/m-p/580676#M215745 2014-03-31T11:53:05Z Re: Re: How to create Last three months rolling average https://community.qlik.com/t5/QlikView/How-to-create-Last-three-months-rolling-average/m-p/580677#M215746 <HTML><HEAD></HEAD><BODY><P>Anybody give me the suggestion.</P></BODY></HTML> Mon, 31 Mar 2014 12:12:34 GMT https://community.qlik.com/t5/QlikView/How-to-create-Last-three-months-rolling-average/m-p/580677#M215746 2014-03-31T12:12:34Z Re: How to create Last three months rolling average https://community.qlik.com/t5/QlikView/How-to-create-Last-three-months-rolling-average/m-p/580678#M215747 <HTML><HEAD></HEAD><BODY><P>Any body can help me how to create last three months rolling average.</P></BODY></HTML> Mon, 31 Mar 2014 14:57:57 GMT https://community.qlik.com/t5/QlikView/How-to-create-Last-three-months-rolling-average/m-p/580678#M215747 2014-03-31T14:57:57Z Re: How to create Last three months rolling average https://community.qlik.com/t5/QlikView/How-to-create-Last-three-months-rolling-average/m-p/580679#M215748 <HTML><HEAD></HEAD><BODY><P>You should be able to use something like this in a set to calculate this:</P><P></P><P><SPAN class="s1">rangeavg</SPAN><SPAN class="s2">(</SPAN><SPAN class="s1">above</SPAN><SPAN class="s2">(</SPAN><SPAN class="s1">sum</SPAN><SPAN class="s2">(</SPAN>[Market Share Units - MKT UOM]<SPAN class="s2">),0,3)) </SPAN></P><P></P><P>Best,</P><P></P><P>Matt</P></BODY></HTML> Mon, 31 Mar 2014 16:32:59 GMT https://community.qlik.com/t5/QlikView/How-to-create-Last-three-months-rolling-average/m-p/580679#M215748 2014-03-31T16:32:59Z Re: How to create Last three months rolling average https://community.qlik.com/t5/QlikView/How-to-create-Last-three-months-rolling-average/m-p/580680#M215749 <HTML><HEAD></HEAD><BODY><P>Thanks Matt, But I need back-end formula. i want to create the another list box for Rolling Average. Above is not working in the back-end.</P></BODY></HTML> Mon, 31 Mar 2014 16:45:03 GMT https://community.qlik.com/t5/QlikView/How-to-create-Last-three-months-rolling-average/m-p/580680#M215749 2014-03-31T16:45:03Z