topic Re: Previous 30 rows average in QlikView https://community.qlik.com/t5/QlikView/Previous-30-rows-average/m-p/870557#M304296 <HTML><HEAD></HEAD><BODY><H6 style="font-style: inherit; font-family: inherit;"></H6><P style="font-weight: inherit; font-style: inherit; font-family: inherit;">Manyyyy thank's</P></BODY></HTML> Mon, 22 Jun 2015 09:27:03 GMT ecabanas 2015-06-22T09:27:03Z Previous 30 rows average https://community.qlik.com/t5/QlikView/Previous-30-rows-average/m-p/870555#M304294 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I would like to have the last 30 rows average froma table, any idea?</P><P></P><P>thank's</P><P><IMG alt="last 30 rows.jpg" class="jive-image image-1" src="/legacyfs/online/90246_last 30 rows.jpg" style="height: auto;" /></P></BODY></HTML> Mon, 22 Jun 2015 09:03:14 GMT https://community.qlik.com/t5/QlikView/Previous-30-rows-average/m-p/870555#M304294 ecabanas 2015-06-22T09:03:14Z Re: Previous 30 rows average https://community.qlik.com/t5/QlikView/Previous-30-rows-average/m-p/870556#M304295 <HTML><HEAD></HEAD><BODY><P>in you straight table chart, try something like</P><P></P><P>=rangeavg( below( sum(TotalOrders), 1, 30) )</P><P></P><P>replacing sum(TotalOrders) with your expression.</P></BODY></HTML> Mon, 22 Jun 2015 09:18:08 GMT https://community.qlik.com/t5/QlikView/Previous-30-rows-average/m-p/870556#M304295 swuehl 2015-06-22T09:18:08Z Re: Previous 30 rows average https://community.qlik.com/t5/QlikView/Previous-30-rows-average/m-p/870557#M304296 <HTML><HEAD></HEAD><BODY><H6 style="font-style: inherit; font-family: inherit;"></H6><P style="font-weight: inherit; font-style: inherit; font-family: inherit;">Manyyyy thank's</P></BODY></HTML> Mon, 22 Jun 2015 09:27:03 GMT https://community.qlik.com/t5/QlikView/Previous-30-rows-average/m-p/870557#M304296 ecabanas 2015-06-22T09:27:03Z