topic Re: Moving Average using a variable interval in QlikView https://community.qlik.com/t5/QlikView/Moving-Average-using-a-variable-interval/m-p/660903#M1087922 <HTML><HEAD></HEAD><BODY><P>Maybe look at the Above() function.</P></BODY></HTML> Wed, 11 Jun 2014 16:33:38 GMT Jason_Michaelides 2014-06-11T16:33:38Z Moving Average using a variable interval https://community.qlik.com/t5/QlikView/Moving-Average-using-a-variable-interval/m-p/660902#M1087921 <HTML><HEAD></HEAD><BODY><P>I have a problem that i really don't know how to solve. Basically what i need to achieve is to build a table that contains a moving average for a list of items based on a rolling date. I need to build it in the script cause i need it later to make other calculations. The difficult part is that the interval should be different for every single item. i created an example in excel, where i calculated a 3 days moving average for item A and a 5 days moving average for item B.</P><P></P><TABLE border="1" class="jiveBorder" height="74" style="border: 1px solid #000000; width: 232px; height: 74px;" width="230"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>ITEM</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>MOVING AVG INTERVAL</STRONG></TH></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">3</TD></TR><TR><TD style="padding: 2px;">B</TD><TD style="padding: 2px;">5</TD></TR></TBODY></TABLE></BODY></HTML> Wed, 11 Jun 2014 16:18:14 GMT https://community.qlik.com/t5/QlikView/Moving-Average-using-a-variable-interval/m-p/660902#M1087921 gian_ve77 2014-06-11T16:18:14Z Re: Moving Average using a variable interval https://community.qlik.com/t5/QlikView/Moving-Average-using-a-variable-interval/m-p/660903#M1087922 <HTML><HEAD></HEAD><BODY><P>Maybe look at the Above() function.</P></BODY></HTML> Wed, 11 Jun 2014 16:33:38 GMT https://community.qlik.com/t5/QlikView/Moving-Average-using-a-variable-interval/m-p/660903#M1087922 Jason_Michaelides 2014-06-11T16:33:38Z Re: Moving Average using a variable interval https://community.qlik.com/t5/QlikView/Moving-Average-using-a-variable-interval/m-p/660904#M1087923 <HTML><HEAD></HEAD><BODY><P>It would work if i did it in a chart or a table, but i need to obtain the same result in my script. Any suggestion?</P></BODY></HTML> Thu, 12 Jun 2014 14:30:29 GMT https://community.qlik.com/t5/QlikView/Moving-Average-using-a-variable-interval/m-p/660904#M1087923 gian_ve77 2014-06-12T14:30:29Z