This content has been marked as final. Show 4 replies
Is Is Average of Average Possible in Qlikview??
I have written Two expression in a Pivot with a dimension as Salesperson and SalesOrderID
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.