topic How to get average order per week in QlikView https://community.qlik.com/t5/QlikView/How-to-get-average-order-per-week/m-p/154800#M31282 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have a qlik view application that shows the total orders ordered per day (or week, month, etc).</P><P>My customer want to have an gauge 'Orders this week vs Average orders per week'. I am wondering or some knows how I can determine the average amount of orders per week?</P><P>Does someone have an idea?</P></BODY></HTML> Tue, 17 Nov 2009 20:23:49 GMT 2009-11-17T20:23:49Z How to get average order per week https://community.qlik.com/t5/QlikView/How-to-get-average-order-per-week/m-p/154800#M31282 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have a qlik view application that shows the total orders ordered per day (or week, month, etc).</P><P>My customer want to have an gauge 'Orders this week vs Average orders per week'. I am wondering or some knows how I can determine the average amount of orders per week?</P><P>Does someone have an idea?</P></BODY></HTML> Tue, 17 Nov 2009 20:23:49 GMT https://community.qlik.com/t5/QlikView/How-to-get-average-order-per-week/m-p/154800#M31282 2009-11-17T20:23:49Z How to get average order per week https://community.qlik.com/t5/QlikView/How-to-get-average-order-per-week/m-p/154801#M31283 <HTML><HEAD></HEAD><BODY><P>Together with my collague I have found a solution that can also be useful for you:</P><P>Average per week = Num((Sum(OrderCounter) / Count(Distinct WeekYear)), '#####.')</P><P>Together with 'set analysis' that fix to the last week you can get the orders this week vs average orders per week.</P><P></P><P></P><P></P></BODY></HTML> Tue, 17 Nov 2009 21:08:26 GMT https://community.qlik.com/t5/QlikView/How-to-get-average-order-per-week/m-p/154801#M31283 2009-11-17T21:08:26Z