topic Using Avg in a Pivot Table in QlikView https://community.qlik.com/t5/QlikView/Using-Avg-in-a-Pivot-Table/m-p/264705#M581306 <HTML><HEAD></HEAD><BODY><P>How about sum(driver age)/count(distinct policy number)</P></BODY></HTML> Wed, 11 Jan 2012 02:41:26 GMT 2012-01-11T02:41:26Z Using Avg in a Pivot Table https://community.qlik.com/t5/QlikView/Using-Avg-in-a-Pivot-Table/m-p/264703#M581304 <HTML><HEAD></HEAD><BODY><P>I am trying to get the average age of drivers by policy number.&nbsp; Using Avg([Driver Age]) gets me the same average for each policy.&nbsp; Using the aggr function,</P><P>Aggr(Avg([Driver Age]), [Policy Number]), gets the same result.&nbsp; Adding Total to the expression returns null.</P></BODY></HTML> Tue, 10 Jan 2012 22:51:23 GMT https://community.qlik.com/t5/QlikView/Using-Avg-in-a-Pivot-Table/m-p/264703#M581304 2012-01-10T22:51:23Z Using Avg in a Pivot Table https://community.qlik.com/t5/QlikView/Using-Avg-in-a-Pivot-Table/m-p/264704#M581305 <HTML><HEAD></HEAD><BODY><P>How about AGGR(AVG(SUM([Driver Age])),[Policy Number])</P></BODY></HTML> Tue, 10 Jan 2012 23:10:32 GMT https://community.qlik.com/t5/QlikView/Using-Avg-in-a-Pivot-Table/m-p/264704#M581305 Anonymous 2012-01-10T23:10:32Z Using Avg in a Pivot Table https://community.qlik.com/t5/QlikView/Using-Avg-in-a-Pivot-Table/m-p/264705#M581306 <HTML><HEAD></HEAD><BODY><P>How about sum(driver age)/count(distinct policy number)</P></BODY></HTML> Wed, 11 Jan 2012 02:41:26 GMT https://community.qlik.com/t5/QlikView/Using-Avg-in-a-Pivot-Table/m-p/264705#M581306 2012-01-11T02:41:26Z Using Avg in a Pivot Table https://community.qlik.com/t5/QlikView/Using-Avg-in-a-Pivot-Table/m-p/264706#M581307 <HTML><HEAD></HEAD><BODY><P> Where you are adding the total&nbsp; are you giving </P><P></P><P>like&nbsp; this&nbsp; Aggr(total&nbsp; Avg([Driver Age]), [Policy Number]))&nbsp; or</P><P></P><P>Aggr(Avg(total&nbsp; [Driver Age]), [Policy Number]))&nbsp; this should not give you null </P></BODY></HTML> Wed, 11 Jan 2012 09:28:54 GMT https://community.qlik.com/t5/QlikView/Using-Avg-in-a-Pivot-Table/m-p/264706#M581307 qliksus 2012-01-11T09:28:54Z