topic Re: Running average above 10 minutes in QlikView https://community.qlik.com/t5/QlikView/Running-average-above-10-minutes/m-p/437706#M163200 <HTML><HEAD></HEAD><BODY><P>Hi!</P><P></P><P><SPAN class="hps">Here is a</SPAN> <SPAN class="hps">simple example</SPAN>. <SPAN class="hps">Hope that helps</SPAN>.</P><P></P><P><SPAN class="hps"></SPAN><SPAN class="hps"></SPAN></P><P>Rebeca</P></BODY></HTML> Fri, 14 Dec 2012 15:25:32 GMT 2012-12-14T15:25:32Z Running average above 10 minutes https://community.qlik.com/t5/QlikView/Running-average-above-10-minutes/m-p/437705#M163199 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have a table with date, time and count and I need a running average of the last 10 minutes. I found the following post (<A _jive_internal="true" class="loading" href="https://community.qlik.com/message/95999#95999" title="http://community.qlik.com/message/95999#95999">http://community.qlik.com/message/95999#95999</A>). But im not get this solution working for my problem. Thanks for any help or or ideas.</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>date</STRONG></SPAN><BR /></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>time</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>count</STRONG></SPAN></TH></TR><TR><TD>01.05.2012</TD><TD>00:00</TD><TD>2</TD></TR><TR><TD>01.05.2012</TD><TD><P>00:01</P></TD><TD>5</TD></TR><TR><TD>01.05.2012</TD><TD><P>00:02</P></TD><TD>3</TD></TR><TR><TD>01.05.2012</TD><TD><P>00:03</P></TD><TD>4</TD></TR><TR><TD>01.05.2012</TD><TD><P>00:04</P></TD><TD>2</TD></TR><TR><TD>01.05.2012</TD><TD><P>00:05</P></TD><TD>1</TD></TR><TR><TD>01.05.2012</TD><TD><P>00:06</P></TD><TD>3</TD></TR><TR><TD>01.05.2012</TD><TD><P>00:07</P></TD><TD>1</TD></TR><TR><TD>01.05.2012</TD><TD><P>00:08</P></TD><TD>3</TD></TR><TR><TD>01.05.2012</TD><TD><P>00:09</P></TD><TD>4</TD></TR><TR><TD>01.05.2012</TD><TD><P>00:10</P></TD><TD>12</TD></TR><TR><TD>01.05.2012</TD><TD><P>00:11</P></TD><TD>5</TD></TR><TR><TD>...</TD><TD><P>...</P></TD><TD>...</TD></TR><TR><TD>01.06.2012</TD><TD>23:59</TD><TD>4</TD></TR></TBODY></TABLE></BODY></HTML> Fri, 14 Dec 2012 11:05:25 GMT https://community.qlik.com/t5/QlikView/Running-average-above-10-minutes/m-p/437705#M163199 qlikconsultant 2012-12-14T11:05:25Z Re: Running average above 10 minutes https://community.qlik.com/t5/QlikView/Running-average-above-10-minutes/m-p/437706#M163200 <HTML><HEAD></HEAD><BODY><P>Hi!</P><P></P><P><SPAN class="hps">Here is a</SPAN> <SPAN class="hps">simple example</SPAN>. <SPAN class="hps">Hope that helps</SPAN>.</P><P></P><P><SPAN class="hps"></SPAN><SPAN class="hps"></SPAN></P><P>Rebeca</P></BODY></HTML> Fri, 14 Dec 2012 15:25:32 GMT https://community.qlik.com/t5/QlikView/Running-average-above-10-minutes/m-p/437706#M163200 2012-12-14T15:25:32Z Re: Running average above 10 minutes https://community.qlik.com/t5/QlikView/Running-average-above-10-minutes/m-p/437707#M163201 <HTML><HEAD></HEAD><BODY><P>I found a different solution:</P><P></P><P>round((above(sum(count),10)</P><P>+above(sum(count),9)</P><P>+above(sum(count),8)</P><P>+above(sum(count),7)</P><P>+above(sum(count),6)</P><P>+above(sum(count),5)</P><P>+above(sum(count),4)</P><P>+above(sum(count),3)</P><P>+above(sum(count),2)</P><P>+above(sum(count),1))/10)</P></BODY></HTML> Fri, 14 Dec 2012 17:55:31 GMT https://community.qlik.com/t5/QlikView/Running-average-above-10-minutes/m-p/437707#M163201 qlikconsultant 2012-12-14T17:55:31Z