4 Replies Latest reply: Aug 20, 2010 7:33 AM by APS RSS

    Is Average of Average Possible in Qlikview

    ModiAnkit

      HI,

      Is Is Average of Average Possible in Qlikview??

      I have written Two expression in a Pivot with a dimension as Salesperson and SalesOrderID

      1) Avg(OrderQty)

      2) sum(OrderQty)/count(SalesID)

       

      Now in other pivot i need and average of above 2 expression with dimension as SalesPerson??

      avg(sum(OrderQty)/count(SalesID)) -- THIS IS NOT WORKING

      avg( Avg(OrderQty)) -- THIS IS NOT WORKING

      Pls any one can suggest an solution..

      Thanks in advance.

      Regards.

      Ankit