topic Moving average 8 weeks in QlikView https://community.qlik.com/t5/QlikView/Moving-average-8-weeks/m-p/542346#M202691 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I must calculate 8 weeks moving average and not rolling average.</P><P>The calcul must start at the 8 weeks and move to the last week on the data.</P><P></P><P>It must calculate as "Excel moving average".</P><P></P><P>Why isn't works ? because it mustn't actualize on the date selection but actualize on the others selection. </P><P></P><P>I should display it on a chart with 2 others expressions with bars and the moving average on a line expression.</P><P></P><P>Thank you for your interest and help ! <IMG src="https://community.qlik.com/legacyfs/online/emoticons/wink.png" /></P></BODY></HTML> Thu, 19 Sep 2013 10:27:59 GMT 2013-09-19T10:27:59Z Moving average 8 weeks https://community.qlik.com/t5/QlikView/Moving-average-8-weeks/m-p/542346#M202691 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I must calculate 8 weeks moving average and not rolling average.</P><P>The calcul must start at the 8 weeks and move to the last week on the data.</P><P></P><P>It must calculate as "Excel moving average".</P><P></P><P>Why isn't works ? because it mustn't actualize on the date selection but actualize on the others selection. </P><P></P><P>I should display it on a chart with 2 others expressions with bars and the moving average on a line expression.</P><P></P><P>Thank you for your interest and help ! <IMG src="https://community.qlik.com/legacyfs/online/emoticons/wink.png" /></P></BODY></HTML> Thu, 19 Sep 2013 10:27:59 GMT https://community.qlik.com/t5/QlikView/Moving-average-8-weeks/m-p/542346#M202691 2013-09-19T10:27:59Z