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

    Is Average of Average Possible in Qlikview



      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.