topic Re: Moving Average not working in QlikView https://community.qlik.com/t5/QlikView/Moving-Average-not-working/m-p/1524801#M748827 <P>Try this</P><PRE>Aggr(If(RowNo() &gt; 2 and RowNo() &lt;&gt; NoOfRows(), RangeAvg(Above(Sum(Sales), 0, 4))), t)</PRE> Fri, 28 Dec 2018 11:54:13 GMT sunny_talwar 2018-12-28T11:54:13Z Moving Average not working https://community.qlik.com/t5/QlikView/Moving-Average-not-working/m-p/1524485#M748822 <P>Dear all</P><P>Kindly advise why 4 quarters moving average MA(4) is not working after adding year and quarter in the dimension ?.</P><P>The correct answer should be as follows:&nbsp;</P><TABLE><TBODY><TR><TD><STRONG>t</STRONG></TD><TD><STRONG>Year</STRONG></TD><TD>Quarter</TD><TD>Sales</TD><TD>MA(4)</TD></TR><TR><TD>1</TD><TD>2014</TD><TD>1</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4.8</TD><TD>&nbsp;</TD></TR><TR><TD>2</TD><TD>2014</TD><TD>2</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4.1</TD><TD>&nbsp;</TD></TR><TR><TD>3</TD><TD>2014</TD><TD>3</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6.0</TD><TD>5.4</TD></TR><TR><TD>4</TD><TD>2014</TD><TD>4</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6.5</TD><TD>5.6</TD></TR><TR><TD>5</TD><TD>2015</TD><TD>1</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5.8</TD><TD>5.9</TD></TR><TR><TD>6</TD><TD>2015</TD><TD>2</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5.2</TD><TD>6.1</TD></TR><TR><TD>7</TD><TD>2015</TD><TD>3</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6.8</TD><TD>6.3</TD></TR><TR><TD>8</TD><TD>2015</TD><TD>4</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7.4</TD><TD>6.4</TD></TR><TR><TD>9</TD><TD>2016</TD><TD>1</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6.0</TD><TD>6.5</TD></TR><TR><TD>10</TD><TD>2016</TD><TD>2</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5.6</TD><TD>6.6</TD></TR><TR><TD>11</TD><TD>2016</TD><TD>3</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7.5</TD><TD>6.7</TD></TR><TR><TD>12</TD><TD>2016</TD><TD>4</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7.8</TD><TD>6.8</TD></TR><TR><TD>13</TD><TD>2017</TD><TD>1</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6.3</TD><TD>6.9</TD></TR><TR><TD>14</TD><TD>2017</TD><TD>2</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5.9</TD><TD>7.0</TD></TR><TR><TD>15</TD><TD>2017</TD><TD>3</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8.0</TD><TD>7.2</TD></TR><TR><TD>16</TD><TD>2017</TD><TD>4</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8.4</TD><TD>&nbsp;</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Thank you</P><P>Tracy</P> Sat, 16 Nov 2024 04:53:09 GMT https://community.qlik.com/t5/QlikView/Moving-Average-not-working/m-p/1524485#M748822 tracycrown 2024-11-16T04:53:09Z Re: Moving Average not working https://community.qlik.com/t5/QlikView/Moving-Average-not-working/m-p/1524496#M748823 <P>Try this</P><PRE>Aggr(RangeAvg(Above(Sum(Sales), 0, 4)), t)</PRE> Thu, 27 Dec 2018 16:39:42 GMT https://community.qlik.com/t5/QlikView/Moving-Average-not-working/m-p/1524496#M748823 sunny_talwar 2018-12-27T16:39:42Z Re: Moving Average not working https://community.qlik.com/t5/QlikView/Moving-Average-not-working/m-p/1524601#M748825 <P>Dear Sunny</P><P>The answer is correct but how&nbsp;to make first two (t1 &amp; t2) and last (t16) records of MA(4)&nbsp;equal&nbsp;blank ?.</P><P>Thank you</P><P>Tracy</P> Thu, 27 Dec 2018 22:57:32 GMT https://community.qlik.com/t5/QlikView/Moving-Average-not-working/m-p/1524601#M748825 tracycrown 2018-12-27T22:57:32Z Re: Moving Average not working https://community.qlik.com/t5/QlikView/Moving-Average-not-working/m-p/1524801#M748827 <P>Try this</P><PRE>Aggr(If(RowNo() &gt; 2 and RowNo() &lt;&gt; NoOfRows(), RangeAvg(Above(Sum(Sales), 0, 4))), t)</PRE> Fri, 28 Dec 2018 11:54:13 GMT https://community.qlik.com/t5/QlikView/Moving-Average-not-working/m-p/1524801#M748827 sunny_talwar 2018-12-28T11:54:13Z