topic Rolling Average Help! in QlikView https://community.qlik.com/t5/QlikView/Rolling-Average-Help/m-p/711005#M1063495 <HTML><HEAD></HEAD><BODY><P>Greetings, </P><P></P><P>This is my first post/question here... I'm a 'newbie' to QlikView.</P><P></P><P>I was wondering if anyone could help me with a set analysis calculation for rolling averages...</P><P></P><P>I'm looking to calculate the 4 week rolling average.</P><P></P><P>Also, if it's possible, I'm looking to also calculate the previous month's 4 week rolling average.</P><P></P><P>See the following table: </P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Week</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Date Ending </STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Prod</STRONG></TH></TR><TR><TD style="padding: 2px;"><P>48</P></TD><TD style="padding: 2px;">12/4/2010</TD><TD style="padding: 2px;">88,491</TD></TR><TR><TD style="padding: 2px;">49</TD><TD style="padding: 2px;">12/11/2010</TD><TD style="padding: 2px;">122,631</TD></TR><TR><TD style="padding: 2px;">50</TD><TD style="padding: 2px;">12/18/2010</TD><TD style="padding: 2px;">126,258</TD></TR><TR><TD style="padding: 2px;">51</TD><TD style="padding: 2px;">12/25/2010</TD><TD style="padding: 2px;">87,306</TD></TR></TBODY></TABLE><P></P><P>Any input is greatly appreciated... If I haven't provided enough info let me know and I can provide more.</P><P></P><P>Thanks <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /> </P></BODY></HTML> Tue, 16 Sep 2014 15:02:09 GMT 2014-09-16T15:02:09Z Rolling Average Help! https://community.qlik.com/t5/QlikView/Rolling-Average-Help/m-p/711005#M1063495 <HTML><HEAD></HEAD><BODY><P>Greetings, </P><P></P><P>This is my first post/question here... I'm a 'newbie' to QlikView.</P><P></P><P>I was wondering if anyone could help me with a set analysis calculation for rolling averages...</P><P></P><P>I'm looking to calculate the 4 week rolling average.</P><P></P><P>Also, if it's possible, I'm looking to also calculate the previous month's 4 week rolling average.</P><P></P><P>See the following table: </P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Week</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Date Ending </STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Prod</STRONG></TH></TR><TR><TD style="padding: 2px;"><P>48</P></TD><TD style="padding: 2px;">12/4/2010</TD><TD style="padding: 2px;">88,491</TD></TR><TR><TD style="padding: 2px;">49</TD><TD style="padding: 2px;">12/11/2010</TD><TD style="padding: 2px;">122,631</TD></TR><TR><TD style="padding: 2px;">50</TD><TD style="padding: 2px;">12/18/2010</TD><TD style="padding: 2px;">126,258</TD></TR><TR><TD style="padding: 2px;">51</TD><TD style="padding: 2px;">12/25/2010</TD><TD style="padding: 2px;">87,306</TD></TR></TBODY></TABLE><P></P><P>Any input is greatly appreciated... If I haven't provided enough info let me know and I can provide more.</P><P></P><P>Thanks <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /> </P></BODY></HTML> Tue, 16 Sep 2014 15:02:09 GMT https://community.qlik.com/t5/QlikView/Rolling-Average-Help/m-p/711005#M1063495 2014-09-16T15:02:09Z Re: Rolling Average Help! https://community.qlik.com/t5/QlikView/Rolling-Average-Help/m-p/711006#M1063496 <HTML><HEAD></HEAD><BODY><P>Create a Straight Table</P><P>Dimension</P><P>Week</P><P></P><P>Expression</P><P>SUM(Sales)</P><P></P><P>RangeAvg(Above(SUM(Sales),0,4))</P></BODY></HTML> Tue, 16 Sep 2014 15:03:54 GMT https://community.qlik.com/t5/QlikView/Rolling-Average-Help/m-p/711006#M1063496 MK_QSL 2014-09-16T15:03:54Z