topic Need to Calculate last three weeks average in Pivot in QlikView https://community.qlik.com/t5/QlikView/Need-to-Calculate-last-three-weeks-average-in-Pivot/m-p/55088#M9149 <HTML><HEAD></HEAD><BODY><P>Please find attached sample report</P><P>As of Date</P><P>8/29/2017</P><P>9/5/2017</P><P>9/12/2017</P><P>9/19/2017 -Current week</P><P>For these three weeks no issues 8/29/2017,9/5/2017,9/12/2017</P><P>For current week we need to do the below calculation</P><P>D51 is =AVERAGE(D6,D21,D36)</P><P>D59 is =100*((D50-D53)-(K35-K38))</P><P></P><P>Could you please give some idea how to achive this in qlikview.</P></BODY></HTML> Fri, 18 May 2018 08:57:01 GMT Anonymous 2018-05-18T08:57:01Z Need to Calculate last three weeks average in Pivot https://community.qlik.com/t5/QlikView/Need-to-Calculate-last-three-weeks-average-in-Pivot/m-p/55088#M9149 <HTML><HEAD></HEAD><BODY><P>Please find attached sample report</P><P>As of Date</P><P>8/29/2017</P><P>9/5/2017</P><P>9/12/2017</P><P>9/19/2017 -Current week</P><P>For these three weeks no issues 8/29/2017,9/5/2017,9/12/2017</P><P>For current week we need to do the below calculation</P><P>D51 is =AVERAGE(D6,D21,D36)</P><P>D59 is =100*((D50-D53)-(K35-K38))</P><P></P><P>Could you please give some idea how to achive this in qlikview.</P></BODY></HTML> Fri, 18 May 2018 08:57:01 GMT https://community.qlik.com/t5/QlikView/Need-to-Calculate-last-three-weeks-average-in-Pivot/m-p/55088#M9149 Anonymous 2018-05-18T08:57:01Z Re: Need to Calculate last three weeks average in Pivot https://community.qlik.com/t5/QlikView/Need-to-Calculate-last-three-weeks-average-in-Pivot/m-p/55089#M9150 <HTML><HEAD></HEAD><BODY><P>try this link</P><P><A href="https://community.qlik.com/thread/294093">moving average in a Pivot Table</A></P></BODY></HTML> Fri, 18 May 2018 09:23:59 GMT https://community.qlik.com/t5/QlikView/Need-to-Calculate-last-three-weeks-average-in-Pivot/m-p/55089#M9150 dsharmaqv 2018-05-18T09:23:59Z Re: Need to Calculate last three weeks average in Pivot https://community.qlik.com/t5/QlikView/Need-to-Calculate-last-three-weeks-average-in-Pivot/m-p/55090#M9151 <HTML><HEAD></HEAD><BODY><P>Thanks for reply but i need to show in current week as avg of previous three week</P></BODY></HTML> Fri, 18 May 2018 09:37:32 GMT https://community.qlik.com/t5/QlikView/Need-to-Calculate-last-three-weeks-average-in-Pivot/m-p/55090#M9151 Anonymous 2018-05-18T09:37:32Z