topic Re: Average based on calculated aggr value in QlikView https://community.qlik.com/t5/QlikView/Average-based-on-calculated-aggr-value/m-p/1259653#M859138 <HTML><HEAD></HEAD><BODY><P>Do you expect 7.4? May be this</P><P></P><P><STRONG>=Avg(Aggr(Count(Distinct PAGE),SESSION_ID))</STRONG></P></BODY></HTML> Mon, 30 Jan 2017 18:14:22 GMT sunny_talwar 2017-01-30T18:14:22Z Average based on calculated aggr value https://community.qlik.com/t5/QlikView/Average-based-on-calculated-aggr-value/m-p/1259652#M859137 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I am looking to calculate an average page view per session for a web application.</P><P></P><P>I have managed to use an aggr expression in a table to calculate the unique page views per Session but now want to calculate the average unique page across all sessions loaded into qv.</P><P></P><P>Attached is a sample qv file with data loaded inline and where I have got to so far.</P><P></P><P>What i wanted to do was use count the distinct session IDs and divide by the total amount of unique pages to gain an average.</P><P></P><P>Any help appreciated.</P><P></P><P>Thanks</P><P></P><P>Martin</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Average-based-on-calculated-aggr-value/m-p/1259652#M859137 martin_hamilton 2020-11-25T16:16:04Z Re: Average based on calculated aggr value https://community.qlik.com/t5/QlikView/Average-based-on-calculated-aggr-value/m-p/1259653#M859138 <HTML><HEAD></HEAD><BODY><P>Do you expect 7.4? May be this</P><P></P><P><STRONG>=Avg(Aggr(Count(Distinct PAGE),SESSION_ID))</STRONG></P></BODY></HTML> Mon, 30 Jan 2017 18:14:22 GMT https://community.qlik.com/t5/QlikView/Average-based-on-calculated-aggr-value/m-p/1259653#M859138 sunny_talwar 2017-01-30T18:14:22Z Re: Average based on calculated aggr value https://community.qlik.com/t5/QlikView/Average-based-on-calculated-aggr-value/m-p/1259654#M859139 <HTML><HEAD></HEAD><BODY><P>Thanks Sunny that worked a treat.</P></BODY></HTML> Mon, 30 Jan 2017 22:17:54 GMT https://community.qlik.com/t5/QlikView/Average-based-on-calculated-aggr-value/m-p/1259654#M859139 martin_hamilton 2017-01-30T22:17:54Z