topic Average Order Quantity Calculation in QlikView

Average Order Quantity Calculation

Mon, 17 Jan 2011 22:23:30 GMT

II have no clue how to calculate the value for: Average Order Quantity per Period or per SalesPerson.

I have the Nr of Orders, OrderItems, the Quantity per Item.

i.e.

Jul/2006: Mr. Bond: has made 4 Orders, 29 Order-Items and Quantity of 51

Is the Average: sum(Sales.OrderQuantity) / (count((SalesOrderNr)) / count(distinct((SalesOrderNr))))) ?

Average Order Quantity Calculation

Oleg_Troyansky — Mon, 17 Jan 2011 22:52:37 GMT

You would typically have "Period" or "SalesPerson" as your chart dimension, and in that case, the average Order Quantity would be:

sum(Sales.OrderQuantity) / count(distinct SalesOrderNr)

Average Order Quantity Calculation

Tue, 18 Jan 2011 09:14:41 GMT

Thanks, that helped.

However, I needed on Order Item Level, means: sum(Sales.OrderQuantity)/Count(Sales.OrderNr).
Distinct is in this case not good, it would reduce from Oder-Detail to Oder-Header.