topic Average in QlikView https://community.qlik.com/t5/QlikView/Average/m-p/236599#M87764 <HTML><HEAD></HEAD><BODY><P>Does anyone know how i would go about finding the average sales for a period of three months prior to today's date?</P><P>Any help would be greatly appreciated. Thank you</P></BODY></HTML> Wed, 02 Mar 2011 15:33:05 GMT 2011-03-02T15:33:05Z Average https://community.qlik.com/t5/QlikView/Average/m-p/236599#M87764 <HTML><HEAD></HEAD><BODY><P>Does anyone know how i would go about finding the average sales for a period of three months prior to today's date?</P><P>Any help would be greatly appreciated. Thank you</P></BODY></HTML> Wed, 02 Mar 2011 15:33:05 GMT https://community.qlik.com/t5/QlikView/Average/m-p/236599#M87764 2011-03-02T15:33:05Z Average https://community.qlik.com/t5/QlikView/Average/m-p/236600#M87765 <HTML><HEAD></HEAD><BODY><P>Hi Brian,</P><P>please see the attached example (Set Analysis Tab).</P><P>Good luck!</P><P>Rainer</P></BODY></HTML> Wed, 02 Mar 2011 15:41:29 GMT https://community.qlik.com/t5/QlikView/Average/m-p/236600#M87765 2011-03-02T15:41:29Z Average https://community.qlik.com/t5/QlikView/Average/m-p/236601#M87766 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>The best way would be using set analysis or if statement, you can use the addMonths function to "add" -3 months prior to the date field this getting the desired outcome.</P><P>sum(if(IVDATE&gt;=$(=addMonths(MonthEnd(max(IVDATE)),-3)) and IVDATE&lt;= $(=Today()),sales,0)</P><P>Not verified code but that's the idea..</P></BODY></HTML> Wed, 02 Mar 2011 15:46:42 GMT https://community.qlik.com/t5/QlikView/Average/m-p/236601#M87766 eliran 2011-03-02T15:46:42Z Average https://community.qlik.com/t5/QlikView/Average/m-p/236602#M87767 <HTML><HEAD></HEAD><BODY><P>Thanks for the reply, i was hoping it wouldn't have to come to set analysis <span class="lia-unicode-emoji" title=":disappointed_face:">😞</span></P></BODY></HTML> Wed, 02 Mar 2011 15:49:18 GMT https://community.qlik.com/t5/QlikView/Average/m-p/236602#M87767 2011-03-02T15:49:18Z