topic Rolling Average between two dates in QlikView https://community.qlik.com/t5/QlikView/Rolling-Average-between-two-dates/m-p/982802#M335402 <HTML><HEAD></HEAD><BODY><P>I'm trying to create a rolling average of dates between last month and two moths ago. What I'm doing is:</P><P>=avg({&lt;MonthYear={"&gt;=$(=Date(addmonths(Max(MonthYear), -2),'MMM-YYYY'))</P><P>&lt;=$(=Date(addmonths(Max(MonthYear), -1),'MMM-YYYY'))"}&gt;}[Order Cost])</P><P></P><P>What this seems to do is, give me an average of any month up until last month, so as if the first portion of the set analysis is completely ignored. </P><P></P><P>Any idea what I'm doing wrong there?</P></BODY></HTML> Mon, 24 Aug 2015 18:21:22 GMT 2015-08-24T18:21:22Z Rolling Average between two dates https://community.qlik.com/t5/QlikView/Rolling-Average-between-two-dates/m-p/982802#M335402 <HTML><HEAD></HEAD><BODY><P>I'm trying to create a rolling average of dates between last month and two moths ago. What I'm doing is:</P><P>=avg({&lt;MonthYear={"&gt;=$(=Date(addmonths(Max(MonthYear), -2),'MMM-YYYY'))</P><P>&lt;=$(=Date(addmonths(Max(MonthYear), -1),'MMM-YYYY'))"}&gt;}[Order Cost])</P><P></P><P>What this seems to do is, give me an average of any month up until last month, so as if the first portion of the set analysis is completely ignored. </P><P></P><P>Any idea what I'm doing wrong there?</P></BODY></HTML> Mon, 24 Aug 2015 18:21:22 GMT https://community.qlik.com/t5/QlikView/Rolling-Average-between-two-dates/m-p/982802#M335402 2015-08-24T18:21:22Z Re: Rolling Average between two dates https://community.qlik.com/t5/QlikView/Rolling-Average-between-two-dates/m-p/982803#M335403 <HTML><HEAD></HEAD><BODY><P>I think this will be helpful: <A href="https://community.qlik.com/docs/DOC-4252">Calculating rolling n-period totals, averages or other aggregations</A></P><P></P><P>- Marcus</P></BODY></HTML> Tue, 25 Aug 2015 10:21:52 GMT https://community.qlik.com/t5/QlikView/Rolling-Average-between-two-dates/m-p/982803#M335403 marcus_sommer 2015-08-25T10:21:52Z