topic Average count expression in QlikView https://community.qlik.com/t5/QlikView/Average-count-expression/m-p/1193240#M876609 <HTML><HEAD></HEAD><BODY><P>Location&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Capacity</P><P>GA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20</P><P>CA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10</P><P></P><P></P><P></P><P>Month&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ID&nbsp;&nbsp; Location</P><P>1/1/2016&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp; GA</P><P>1/2/2016&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp; GA</P><P>1/3/2016&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp; GA</P><P>1/3/2016&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 10pt;">CA</SPAN></P><P><SPAN style="font-size: 10pt;">1/4/2016&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CA</SPAN></P><P><SPAN style="font-size: 10pt;">1/5/2016&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CA</SPAN></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>Utilization =&nbsp; <SPAN style="font-size: 10pt;">(count(distinct([ID])) /sum(Capacity)</SPAN></P><P></P><P>How to calculate the average instead of total in the above calc...</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT apthansh 2020-11-25T16:16:04Z Average count expression https://community.qlik.com/t5/QlikView/Average-count-expression/m-p/1193240#M876609 <HTML><HEAD></HEAD><BODY><P>Location&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Capacity</P><P>GA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20</P><P>CA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10</P><P></P><P></P><P></P><P>Month&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ID&nbsp;&nbsp; Location</P><P>1/1/2016&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp; GA</P><P>1/2/2016&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp; GA</P><P>1/3/2016&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp; GA</P><P>1/3/2016&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 10pt;">CA</SPAN></P><P><SPAN style="font-size: 10pt;">1/4/2016&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CA</SPAN></P><P><SPAN style="font-size: 10pt;">1/5/2016&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CA</SPAN></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>Utilization =&nbsp; <SPAN style="font-size: 10pt;">(count(distinct([ID])) /sum(Capacity)</SPAN></P><P></P><P>How to calculate the average instead of total in the above calc...</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Average-count-expression/m-p/1193240#M876609 apthansh 2020-11-25T16:16:04Z Re: Average count expression https://community.qlik.com/t5/QlikView/Average-count-expression/m-p/1193241#M876610 <HTML><HEAD></HEAD><BODY><P>Try like this</P><P></P><P>Count(distinct ID)/sum(Capacity)</P></BODY></HTML> Wed, 26 Oct 2016 03:53:32 GMT https://community.qlik.com/t5/QlikView/Average-count-expression/m-p/1193241#M876610 Anil_Babu_Samineni 2016-10-26T03:53:32Z Re: Average count expression https://community.qlik.com/t5/QlikView/Average-count-expression/m-p/1193242#M876611 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333px;">Avg(count(distinct([ID])) /sum(Capacity)</SPAN></P></BODY></HTML> Wed, 26 Oct 2016 03:55:27 GMT https://community.qlik.com/t5/QlikView/Average-count-expression/m-p/1193242#M876611 vardhancse 2016-10-26T03:55:27Z Re: Average count expression https://community.qlik.com/t5/QlikView/Average-count-expression/m-p/1193243#M876612 <HTML><HEAD></HEAD><BODY><P>use following :-</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3332996368408px;">Avg(count(distinct([ID]) /sum(Capacity))</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3332996368408px;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3332996368408px;">Thanks,</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3332996368408px;"><BR /></SPAN></P></BODY></HTML> Wed, 26 Oct 2016 04:32:15 GMT https://community.qlik.com/t5/QlikView/Average-count-expression/m-p/1193243#M876612 Anonymous 2016-10-26T04:32:15Z Re: Average count expression https://community.qlik.com/t5/QlikView/Average-count-expression/m-p/1193244#M876613 <HTML><HEAD></HEAD><BODY><P>You can't nest aggregation functions like that. You probably need something like</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3332996368408px;">Avg(Aggr(Count(Distinct ID]) / Sum(Capacity), Location))</SPAN></P></BODY></HTML> Wed, 26 Oct 2016 04:56:19 GMT https://community.qlik.com/t5/QlikView/Average-count-expression/m-p/1193244#M876613 jonathandienst 2016-10-26T04:56:19Z