topic Dynamic Average calculation in QlikView https://community.qlik.com/t5/QlikView/Dynamic-Average-calculation/m-p/87676#M603416 <HTML><HEAD></HEAD><BODY><P>Dear advanced users</P><P></P><P>I have a query I am struggling to find a solution for. </P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;">From the sample data attached. I am after calculating the change in the base average when there is a continuous shift in Values. </SPAN></P><P>For example:&nbsp; In the data attached, “Result” for May16 to Dec-16 is less than the the normal Avg ie 92.99% ie 8 continuous points (this is flagged in “Counter” column)</P><P></P><P>My desired result is 87.449% ie the average of May16 to Apr-17 (avg of continuous 12 points - formula in Excel from cell c27 onwards)</P><P></P><P>Regards</P><P>Q</P></BODY></HTML> Tue, 31 Jul 2018 10:35:54 GMT Anonymous 2018-07-31T10:35:54Z Dynamic Average calculation https://community.qlik.com/t5/QlikView/Dynamic-Average-calculation/m-p/87676#M603416 <HTML><HEAD></HEAD><BODY><P>Dear advanced users</P><P></P><P>I have a query I am struggling to find a solution for. </P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;">From the sample data attached. I am after calculating the change in the base average when there is a continuous shift in Values. </SPAN></P><P>For example:&nbsp; In the data attached, “Result” for May16 to Dec-16 is less than the the normal Avg ie 92.99% ie 8 continuous points (this is flagged in “Counter” column)</P><P></P><P>My desired result is 87.449% ie the average of May16 to Apr-17 (avg of continuous 12 points - formula in Excel from cell c27 onwards)</P><P></P><P>Regards</P><P>Q</P></BODY></HTML> Tue, 31 Jul 2018 10:35:54 GMT https://community.qlik.com/t5/QlikView/Dynamic-Average-calculation/m-p/87676#M603416 Anonymous 2018-07-31T10:35:54Z