Discussion Board for collaboration on QlikView Layout & Visualizations.
I am trying to get the average age of drivers by policy number. Using Avg([Driver Age]) gets me the same average for each policy. Using the aggr function,
Aggr(Avg([Driver Age]), [Policy Number]), gets the same result. Adding Total to the expression returns null.
Go to Solution.
How about sum(driver age)/count(distinct policy number)
How about AGGR(AVG(SUM([Driver Age])),[Policy Number])
Where you are adding the total are you giving
like this Aggr(total Avg([Driver Age]), [Policy Number])) or
Aggr(Avg(total [Driver Age]), [Policy Number])) this should not give you null