topic Moving Average in QlikView https://community.qlik.com/t5/QlikView/Moving-Average/m-p/254521#M96364 <HTML><HEAD></HEAD><BODY><P> Beauty, solved the problem, thanks.</P></BODY></HTML> Thu, 24 Nov 2011 19:25:38 GMT Anonymous 2011-11-24T19:25:38Z Moving Average https://community.qlik.com/t5/QlikView/Moving-Average/m-p/254519#M96362 <HTML><HEAD></HEAD><BODY><DIV> </DIV><DIV>Hello ..<BR /> This select returns the cumulative sum.</DIV><DIV> </DIV><DIV><STRONG style=": ; color: #0000ff; font-size: 8pt;"><DIV><SPAN style="color: #0000ff; font-size: 8pt;">LOAD </SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">Produto</SPAN><SPAN style="font-size: 8pt;">,</SPAN><SPAN style="color: #800000; font-size: 8pt;">Vendas</SPAN><SPAN style="font-size: 8pt;">, </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">NumSum</SPAN><SPAN style="font-size: 8pt;"> (</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">PEEK</SPAN><SPAN style="font-size: 8pt;"> ('CSum'),</SPAN><SPAN style="color: #800000; font-size: 8pt;">Vendas</SPAN><SPAN style="font-size: 8pt;">) </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">AS</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">CSum</SPAN><SPAN style="font-size: 8pt;">;<BR /> </SPAN><STRONG style=": ; color: #0000ff; font-size: 8pt;">LOAD</STRONG><SPAN style="color: #0000ff; font-size: 8pt;"> </SPAN><SPAN style="font-size: 8pt;"> *</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">INLINE</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">[ <BR /> Produto, Vendas <BR /> A, 10 <BR /> B,30<BR /> C,10<BR /> D,20<BR /> E,10<BR /> F,20<BR /> ]</SPAN><SPAN style="font-size: 8pt;">; </SPAN></DIV></STRONG></DIV><DIV><SPAN style="font-size: 8pt;"> </SPAN> </DIV><DIV><SPAN style="font-size: 8pt;"> </SPAN></DIV><DIV><SPAN style="font-size: 8pt;"> </SPAN></DIV><DIV><SPAN style="font-size: 8pt;"><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 198pt; border-collapse: collapse;" width="262"><COLGROUP><COL style="width: 50pt; mso-width-source: userset; mso-width-alt: 2413;" width="66" /> <COL span="2" style="width: 74pt; mso-width-source: userset; mso-width-alt: 3584;" width="98" /> </COLGROUP><TBODY><TR style="height: 12.75pt;"><TD class="xl67" height="17" style="border-width: 1pt 0px 0px 1pt; border-style: solid none none solid; border-color: windowtext #333333 #333333 windowtext; width: 50pt; height: 12.75pt; background-color: whitesmoke;" width="66"><STRONG style="font-size: 10pt; font-family: Tahoma;">Produto</STRONG></TD><TD class="xl68" style="border-width: 1pt 0px 0px; border-style: solid none none; border-color: windowtext #333333 #333333; width: 74pt; background-color: whitesmoke;" width="98"><STRONG style="font-size: 10pt; font-family: Tahoma;">Sum (Vendas)</STRONG></TD><TD class="xl73" style="border-width: 1pt 1pt 0px 0px; border-style: solid solid none none; border-color: windowtext windowtext #333333 #333333; width: 74pt; background-color: whitesmoke;" width="98"><STRONG style="font-size: 10pt; font-family: Tahoma;">SUM(CSum)</STRONG></TD></TR><TR style="height: 12.75pt;"><TD class="xl69" height="17" style="border-width: 0px 0px 0px 1pt; border-style: none none none solid; border-color: black black black windowtext; height: 12.75pt; background-color: whitesmoke;"><STRONG style="font-size: 10pt; font-family: Tahoma;"> </STRONG></TD><TD align="right" class="xl65" style="border: 0px black; background-color: whitesmoke;"><STRONG style="color: #000000; font-size: 10pt; font-family: Tahoma;">100</STRONG></TD><TD align="right" class="xl74" style="border-width: 0px 1pt 0px 0px; border-style: none solid none none; border-color: black windowtext black black; background-color: whitesmoke;"><STRONG style="color: #000000; font-size: 10pt; font-family: Tahoma;">350,00</STRONG></TD></TR><TR style="height: 12.75pt;"><TD class="xl70" height="17" style="border-width: 0px 0px 0px 1pt; border-style: none none none solid; border-color: #333333 #333333 #333333 windowtext; height: 12.75pt; background-color: white;"><SPAN style="font-family: Tahoma; font-size: 10pt;">A</SPAN></TD><TD align="right" class="xl66" style="border: 0px #333333; background-color: white;"><SPAN style="font-family: Tahoma; font-size: 10pt;">10</SPAN></TD><TD align="right" class="xl75" style="border-width: 0px 1pt 0px 0px; border-style: none solid none none; border-color: #333333 windowtext #333333 #333333; background-color: white;"><SPAN style="font-family: Tahoma; font-size: 10pt;">10,00</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl70" height="17" style="border-width: 0px 0px 0px 1pt; border-style: none none none solid; border-color: #333333 #333333 #333333 windowtext; height: 12.75pt; background-color: white;"><SPAN style="font-family: Tahoma; font-size: 10pt;">B</SPAN></TD><TD align="right" class="xl66" style="border: 0px #333333; background-color: white;"><SPAN style="font-family: Tahoma; font-size: 10pt;">30</SPAN></TD><TD align="right" class="xl75" style="border-width: 0px 1pt 0px 0px; border-style: none solid none none; border-color: #333333 windowtext #333333 #333333; background-color: white;"><SPAN style="font-family: Tahoma; font-size: 10pt;">40,00</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl70" height="17" style="border-width: 0px 0px 0px 1pt; border-style: none none none solid; border-color: #333333 #333333 #333333 windowtext; height: 12.75pt; background-color: white;"><SPAN style="font-family: Tahoma; font-size: 10pt;">C</SPAN></TD><TD align="right" class="xl66" style="border: 0px #333333; background-color: white;"><SPAN style="font-family: Tahoma; font-size: 10pt;">10</SPAN></TD><TD align="right" class="xl75" style="border-width: 0px 1pt 0px 0px; border-style: none solid none none; border-color: #333333 windowtext #333333 #333333; background-color: white;"><SPAN style="font-family: Tahoma; font-size: 10pt;">50,00</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl70" height="17" style="border-width: 0px 0px 0px 1pt; border-style: none none none solid; border-color: #333333 #333333 #333333 windowtext; height: 12.75pt; background-color: white;"><SPAN style="font-family: Tahoma; font-size: 10pt;">D</SPAN></TD><TD align="right" class="xl66" style="border: 0px #333333; background-color: white;"><SPAN style="font-family: Tahoma; font-size: 10pt;">20</SPAN></TD><TD align="right" class="xl75" style="border-width: 0px 1pt 0px 0px; border-style: none solid none none; border-color: #333333 windowtext #333333 #333333; background-color: white;"><SPAN style="font-family: Tahoma; font-size: 10pt;">70,00</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl70" height="17" style="border-width: 0px 0px 0px 1pt; border-style: none none none solid; border-color: #333333 #333333 #333333 windowtext; height: 12.75pt; background-color: white;"><SPAN style="font-family: Tahoma; font-size: 10pt;">E</SPAN></TD><TD align="right" class="xl66" style="border: 0px #333333; background-color: white;"><SPAN style="font-family: Tahoma; font-size: 10pt;">10</SPAN></TD><TD align="right" class="xl75" style="border-width: 0px 1pt 0px 0px; border-style: none solid none none; border-color: #333333 windowtext #333333 #333333; background-color: white;"><SPAN style="font-family: Tahoma; font-size: 10pt;">80,00</SPAN></TD></TR><TR style="height: 13.5pt;"><TD class="xl71" height="18" style="border-width: 0px 0px 1pt 1pt; border-style: none none solid solid; border-color: #333333 #333333 windowtext windowtext; height: 13.5pt; background-color: white;"><SPAN style="font-family: Tahoma; font-size: 10pt;">F</SPAN></TD><TD align="right" class="xl72" style="border-width: 0px 0px 1pt; border-style: none none solid; border-color: #333333 #333333 windowtext; background-color: white;"><SPAN style="font-family: Tahoma; font-size: 10pt;">20</SPAN></TD><TD align="right" class="xl76" style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #333333 windowtext windowtext #333333; background-color: white;"><SPAN style="font-family: Tahoma; font-size: 10pt;">100,00</SPAN></TD></TR></TBODY></TABLE></SPAN></DIV><DIV><SPAN style="font-size: 8pt;"> </SPAN></DIV><DIV><SPAN style="font-size: 8pt;"> </SPAN></DIV><DIV><SPAN style="font-size: 8pt;"> </SPAN></DIV><DIV><SPAN style="font-size: 8pt;"> </SPAN></DIV><DIV><SPAN style="font-size: 8pt;"> </SPAN></DIV><DIV><SPAN style="font-size: 8pt;"> </SPAN></DIV><DIV><SPAN style="font-size: 8pt;">I need a moving average of these values ​​and not the sum.</SPAN></DIV><DIV><SPAN style="font-size: 8pt;"> </SPAN></DIV><DIV><SPAN style="font-size: 8pt;"><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 326px; border-collapse: collapse;"><COLGROUP><COL style="width: 50pt; mso-width-source: userset; mso-width-alt: 2413;" width="66" /> <COL span="2" style="width: 74pt; mso-width-source: userset; mso-width-alt: 3584;" width="98" /> <COL style="width: 48pt;" width="64" /> </COLGROUP><TBODY><TR style="height: 12.75pt;"><TD class="xl69" height="17" style="border-width: 1pt 0px 0px 1pt; border-style: solid none none solid; border-color: windowtext #333333 #333333 windowtext; width: 50pt; height: 12.75pt; background-color: whitesmoke;" width="66"><STRONG style="font-size: 10pt; font-family: Tahoma;">Produto</STRONG></TD><TD class="xl70" style="border-width: 1pt 0px 0px; border-style: solid none none; border-color: windowtext #333333 #333333; width: 74pt; background-color: whitesmoke;" width="98"><STRONG style="font-size: 10pt; font-family: Tahoma;">Sum (Vendas)</STRONG></TD><TD class="xl70" style="border-width: 1pt 0px 0px; border-style: solid none none; border-color: windowtext #333333 #333333; width: 74pt; background-color: whitesmoke;" width="98"><STRONG style="font-size: 10pt; font-family: Tahoma;">SUM(CSum) </STRONG></TD><TD class="xl71" style="border-width: 1pt 1pt 0px 0px; border-style: solid solid none none; border-color: windowtext; width: 48pt; background-color: transparent;" width="64"><SPAN style="color: #000000; font-size: 10pt;">Avg</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl72" height="17" style="border-width: 0px 0px 0px 1pt; border-style: none none none solid; border-color: black black black windowtext; height: 12.75pt; background-color: whitesmoke;"><STRONG style="font-size: 10pt; font-family: Tahoma;"> </STRONG></TD><TD align="right" class="xl65" style="border: 0px black; background-color: whitesmoke;"><STRONG style="color: #000000; font-size: 10pt; font-family: Tahoma;">100</STRONG></TD><TD align="right" class="xl66" style="border: 0px black; background-color: whitesmoke;"><STRONG style="color: #000000; font-size: 10pt; font-family: Tahoma;">350,00</STRONG></TD><TD class="xl73" style="border-width: 0px 1pt 0px 0px; border-style: none solid none none; border-color: windowtext; background-color: transparent;"></TD></TR><TR style="height: 12.75pt;"><TD class="xl74" height="17" style="border-width: 0px 0px 0px 1pt; border-style: none none none solid; border-color: #333333 #333333 #333333 windowtext; height: 12.75pt; background-color: white;"><SPAN style="font-family: Tahoma; font-size: 10pt;">A</SPAN></TD><TD align="right" class="xl67" style="border: 0px #333333; background-color: white;"><SPAN style="font-family: Tahoma; font-size: 10pt;">10</SPAN></TD><TD align="right" class="xl68" style="border: 0px #333333; background-color: white;"><SPAN style="font-family: Tahoma; font-size: 10pt;">10,00</SPAN></TD><TD align="right" class="xl78" style="border-width: 0px 1pt 0px 0px; border-style: none solid none none; border-color: #333333 windowtext #333333 #333333; background-color: white;"><SPAN style="font-family: Tahoma; font-size: 10pt;">10,0</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl74" height="17" style="border-width: 0px 0px 0px 1pt; border-style: none none none solid; border-color: #333333 #333333 #333333 windowtext; height: 12.75pt; background-color: white;"><SPAN style="font-family: Tahoma; font-size: 10pt;">B</SPAN></TD><TD align="right" class="xl67" style="border: 0px #333333; background-color: white;"><SPAN style="font-family: Tahoma; font-size: 10pt;">30</SPAN></TD><TD align="right" class="xl68" style="border: 0px #333333; background-color: white;"><SPAN style="font-family: Tahoma; font-size: 10pt;">40,00</SPAN></TD><TD align="right" class="xl78" style="border-width: 0px 1pt 0px 0px; border-style: none solid none none; border-color: #333333 windowtext #333333 #333333; background-color: white;"><SPAN style="font-family: Tahoma; font-size: 10pt;">20,0</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl74" height="17" style="border-width: 0px 0px 0px 1pt; border-style: none none none solid; border-color: #333333 #333333 #333333 windowtext; height: 12.75pt; background-color: white;"><SPAN style="font-family: Tahoma; font-size: 10pt;">C</SPAN></TD><TD align="right" class="xl67" style="border: 0px #333333; background-color: white;"><SPAN style="font-family: Tahoma; font-size: 10pt;">10</SPAN></TD><TD align="right" class="xl68" style="border: 0px #333333; background-color: white;"><SPAN style="font-family: Tahoma; font-size: 10pt;">50,00</SPAN></TD><TD align="right" class="xl78" style="border-width: 0px 1pt 0px 0px; border-style: none solid none none; border-color: #333333 windowtext #333333 #333333; background-color: white;"><SPAN style="font-family: Tahoma; font-size: 10pt;">16,7</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl74" height="17" style="border-width: 0px 0px 0px 1pt; border-style: none none none solid; border-color: #333333 #333333 #333333 windowtext; height: 12.75pt; background-color: white;"><SPAN style="font-family: Tahoma; font-size: 10pt;">D</SPAN></TD><TD align="right" class="xl67" style="border: 0px #333333; background-color: white;"><SPAN style="font-family: Tahoma; font-size: 10pt;">20</SPAN></TD><TD align="right" class="xl68" style="border: 0px #333333; background-color: white;"><SPAN style="font-family: Tahoma; font-size: 10pt;">70,00</SPAN></TD><TD align="right" class="xl78" style="border-width: 0px 1pt 0px 0px; border-style: none solid none none; border-color: #333333 windowtext #333333 #333333; background-color: white;"><SPAN style="font-family: Tahoma; font-size: 10pt;">17,5</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl74" height="17" style="border-width: 0px 0px 0px 1pt; border-style: none none none solid; border-color: #333333 #333333 #333333 windowtext; height: 12.75pt; background-color: white;"><SPAN style="font-family: Tahoma; font-size: 10pt;">E</SPAN></TD><TD align="right" class="xl67" style="border: 0px #333333; background-color: white;"><SPAN style="font-family: Tahoma; font-size: 10pt;">10</SPAN></TD><TD align="right" class="xl68" style="border: 0px #333333; background-color: white;"><SPAN style="font-family: Tahoma; font-size: 10pt;">80,00</SPAN></TD><TD align="right" class="xl78" style="border-width: 0px 1pt 0px 0px; border-style: none solid none none; border-color: #333333 windowtext #333333 #333333; background-color: white;"><SPAN style="font-family: Tahoma; font-size: 10pt;">16,0</SPAN></TD></TR><TR style="height: 13.5pt;"><TD class="xl75" height="18" style="border-width: 0px 0px 1pt 1pt; border-style: none none solid solid; border-color: #333333 #333333 windowtext windowtext; height: 13.5pt; background-color: white;"><SPAN style="font-family: Tahoma; font-size: 10pt;">F</SPAN></TD><TD align="right" class="xl76" style="border-width: 0px 0px 1pt; border-style: none none solid; border-color: #333333 #333333 windowtext; background-color: white;"><SPAN style="font-family: Tahoma; font-size: 10pt;">20</SPAN></TD><TD align="right" class="xl77" style="border-width: 0px 0px 1pt; border-style: none none solid; border-color: #333333 #333333 windowtext; background-color: white;"><SPAN style="font-family: Tahoma; font-size: 10pt;">100,00</SPAN></TD><TD align="right" class="xl79" style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #333333 windowtext windowtext #333333; background-color: white;"><SPAN style="font-family: Tahoma; font-size: 10pt;">16,7</SPAN></TD></TR></TBODY></TABLE></SPAN></DIV></BODY></HTML> Thu, 24 Nov 2011 17:19:33 GMT https://community.qlik.com/t5/QlikView/Moving-Average/m-p/254519#M96362 Anonymous 2011-11-24T17:19:33Z Moving Average https://community.qlik.com/t5/QlikView/Moving-Average/m-p/254520#M96363 <HTML><HEAD></HEAD><BODY><P>Try dividing by rowno():</P><P></P><P>numsum(Peek('CSum'),Vendas)/RowNo() as RAvg</P><P></P><P>Regards,</P><P>Stefan</P></BODY></HTML> Thu, 24 Nov 2011 19:13:20 GMT https://community.qlik.com/t5/QlikView/Moving-Average/m-p/254520#M96363 swuehl 2011-11-24T19:13:20Z Moving Average https://community.qlik.com/t5/QlikView/Moving-Average/m-p/254521#M96364 <HTML><HEAD></HEAD><BODY><P> Beauty, solved the problem, thanks.</P></BODY></HTML> Thu, 24 Nov 2011 19:25:38 GMT https://community.qlik.com/t5/QlikView/Moving-Average/m-p/254521#M96364 Anonymous 2011-11-24T19:25:38Z