https://community.qlik.com/t5/App-Development/the-difference-of-offset-value-0-and-1/m-p/1991767#M82055 <P><SPAN>the difference of offset value 0 and 1 :</SPAN></P> <P>&nbsp;</P> <P><SPAN>RangeAvg</SPAN><SPAN>(</SPAN><SPAN>above</SPAN><SPAN>(</SPAN><SPAN>Sum</SPAN><SPAN>(</SPAN><SPAN>Sales</SPAN><SPAN>),0,3))&nbsp; and&nbsp;RangeAvg(above(Sum(Sales),1,3))</SPAN></P> Wed, 12 Oct 2022 12:32:15 GMT Mahdoucch03 2022-10-12T12:32:15Z https://community.qlik.com/t5/App-Development/the-difference-of-offset-value-0-and-1/m-p/1991767#M82055 <P><SPAN>the difference of offset value 0 and 1 :</SPAN></P> <P>&nbsp;</P> <P><SPAN>RangeAvg</SPAN><SPAN>(</SPAN><SPAN>above</SPAN><SPAN>(</SPAN><SPAN>Sum</SPAN><SPAN>(</SPAN><SPAN>Sales</SPAN><SPAN>),0,3))&nbsp; and&nbsp;RangeAvg(above(Sum(Sales),1,3))</SPAN></P> Wed, 12 Oct 2022 12:32:15 GMT https://community.qlik.com/t5/App-Development/the-difference-of-offset-value-0-and-1/m-p/1991767#M82055 Mahdoucch03 2022-10-12T12:32:15Z https://community.qlik.com/t5/App-Development/the-difference-of-offset-value-0-and-1/m-p/1991792#M82057 <P>The difference is just the starting point - the current row or one above. It's easily to comprehend by putting both expression in parallel within a table-chart - and then maybe playing a bit with the parameter-values.</P> <P>- Marcus&nbsp;</P> Wed, 12 Oct 2022 13:28:51 GMT https://community.qlik.com/t5/App-Development/the-difference-of-offset-value-0-and-1/m-p/1991792#M82057 marcus_sommer 2022-10-12T13:28:51Z