topic RangAvg(After()) on Script in QlikView https://community.qlik.com/t5/QlikView/RangAvg-After-on-Script/m-p/1999357#M1231842 <P>Hi All,</P> <P>This is my raw data(table1) and i want to use rangeavg&nbsp;<SPAN>Calculate the average for the next three months by site(table2)</SPAN></P> <P>WHY I Want on Script Because after i want to use mode to Diplay .</P> <P>table1</P> <TABLE width="321"> <TBODY> <TR> <TD width="72">SITE</TD> <TD width="88">COMPANY</TD> <TD width="89">YEARMON</TD> <TD width="72">QTY</TD> </TR> <TR> <TD>Taiwan</TD> <TD>LKINTEC</TD> <TD>202209</TD> <TD>100</TD> </TR> <TR> <TD>Taiwan</TD> <TD>LKINTEC</TD> <TD>202210</TD> <TD>200</TD> </TR> <TR> <TD>Taiwan</TD> <TD>LKINTEC</TD> <TD>202211</TD> <TD>300</TD> </TR> <TR> <TD>USA</TD> <TD>APPLE</TD> <TD>202209</TD> <TD>400</TD> </TR> <TR> <TD>USA</TD> <TD>APPLE</TD> <TD>202210</TD> <TD>500</TD> </TR> <TR> <TD>USA</TD> <TD>APPLE</TD> <TD>202211</TD> <TD>600</TD> </TR> </TBODY> </TABLE> <P>chart</P> <TABLE width="321"> <TBODY> <TR> <TD width="72">SITE</TD> <TD width="88">COMPANY</TD> <TD width="89">YEARMON</TD> <TD width="72">QTY</TD> </TR> <TR> <TD>Taiwan</TD> <TD>LKINTEC</TD> <TD>202209</TD> <TD>200</TD> </TR> <TR> <TD>Taiwan</TD> <TD>LKINTEC</TD> <TD>202210</TD> <TD>250</TD> </TR> <TR> <TD>Taiwan</TD> <TD>LJINTEC</TD> <TD>202211</TD> <TD>300</TD> </TR> <TR> <TD>USA</TD> <TD>APPLE</TD> <TD>202209</TD> <TD>500</TD> </TR> <TR> <TD>USA</TD> <TD>APPLE</TD> <TD>202210</TD> <TD>550</TD> </TR> <TR> <TD>USA</TD> <TD>APPLE</TD> <TD>202211</TD> <TD>600</TD> </TR> </TBODY> </TABLE> Mon, 26 Jan 2026 16:26:21 GMT Lyndon921 2026-01-26T16:26:21Z RangAvg(After()) on Script https://community.qlik.com/t5/QlikView/RangAvg-After-on-Script/m-p/1999357#M1231842 <P>Hi All,</P> <P>This is my raw data(table1) and i want to use rangeavg&nbsp;<SPAN>Calculate the average for the next three months by site(table2)</SPAN></P> <P>WHY I Want on Script Because after i want to use mode to Diplay .</P> <P>table1</P> <TABLE width="321"> <TBODY> <TR> <TD width="72">SITE</TD> <TD width="88">COMPANY</TD> <TD width="89">YEARMON</TD> <TD width="72">QTY</TD> </TR> <TR> <TD>Taiwan</TD> <TD>LKINTEC</TD> <TD>202209</TD> <TD>100</TD> </TR> <TR> <TD>Taiwan</TD> <TD>LKINTEC</TD> <TD>202210</TD> <TD>200</TD> </TR> <TR> <TD>Taiwan</TD> <TD>LKINTEC</TD> <TD>202211</TD> <TD>300</TD> </TR> <TR> <TD>USA</TD> <TD>APPLE</TD> <TD>202209</TD> <TD>400</TD> </TR> <TR> <TD>USA</TD> <TD>APPLE</TD> <TD>202210</TD> <TD>500</TD> </TR> <TR> <TD>USA</TD> <TD>APPLE</TD> <TD>202211</TD> <TD>600</TD> </TR> </TBODY> </TABLE> <P>chart</P> <TABLE width="321"> <TBODY> <TR> <TD width="72">SITE</TD> <TD width="88">COMPANY</TD> <TD width="89">YEARMON</TD> <TD width="72">QTY</TD> </TR> <TR> <TD>Taiwan</TD> <TD>LKINTEC</TD> <TD>202209</TD> <TD>200</TD> </TR> <TR> <TD>Taiwan</TD> <TD>LKINTEC</TD> <TD>202210</TD> <TD>250</TD> </TR> <TR> <TD>Taiwan</TD> <TD>LJINTEC</TD> <TD>202211</TD> <TD>300</TD> </TR> <TR> <TD>USA</TD> <TD>APPLE</TD> <TD>202209</TD> <TD>500</TD> </TR> <TR> <TD>USA</TD> <TD>APPLE</TD> <TD>202210</TD> <TD>550</TD> </TR> <TR> <TD>USA</TD> <TD>APPLE</TD> <TD>202211</TD> <TD>600</TD> </TR> </TBODY> </TABLE> Mon, 26 Jan 2026 16:26:21 GMT https://community.qlik.com/t5/QlikView/RangAvg-After-on-Script/m-p/1999357#M1231842 Lyndon921 2026-01-26T16:26:21Z Re: RangAvg(After()) on Script https://community.qlik.com/t5/QlikView/RangAvg-After-on-Script/m-p/1999442#M1231845 <P>Hi, I'm not sure to undertand your question... after is a chart function, so it can't be used in script. In script you have the ppek() function to go to previous rows, so you can load using the order you need (from bottom to top of the table) and use peek() to access the previous row (which would be the next on chart)</P> Wed, 02 Nov 2022 09:04:32 GMT https://community.qlik.com/t5/QlikView/RangAvg-After-on-Script/m-p/1999442#M1231845 rubenmarin 2022-11-02T09:04:32Z