topic Re: A Friday Count in QlikView https://community.qlik.com/t5/QlikView/A-Friday-Count/m-p/561784#M209668 <HTML><HEAD></HEAD><BODY><P>Not if you want something</P></BODY></HTML> Fri, 01 Nov 2013 16:30:08 GMT 2013-11-01T16:30:08Z A Friday Count https://community.qlik.com/t5/QlikView/A-Friday-Count/m-p/561782#M209666 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>It is Friday and almost end of the working day... It seems that my brain stopped working already... Can you please help.</P><P></P><P>I have the following table</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 130px;"><TBODY><TR><TD height="20" width="68">Call ID</TD><TD width="62">User</TD></TR><TR><TD align="right" height="20">1</TD><TD align="right">1589788</TD></TR><TR><TD align="right" height="20">2</TD><TD align="right">1590144</TD></TR><TR><TD align="right" height="20">3</TD><TD align="right">1590500</TD></TR><TR><TD align="right" height="20">4</TD><TD align="right">1589788</TD></TR><TR><TD align="right" height="20">5</TD><TD align="right">1593375</TD></TR><TR><TD align="right" height="20">6</TD><TD align="right">1593731</TD></TR><TR><TD align="right" height="20">7</TD><TD align="right">1594087</TD></TR><TR><TD align="right" height="20">8</TD><TD align="right">1589788</TD></TR><TR><TD align="right" height="20">9</TD><TD align="right">1590144</TD></TR><TR><TD align="right" height="20">10</TD><TD align="right">1590500</TD></TR></TBODY></TABLE><P></P><P>I need to count for the Distinct user the number of call made... I can't list all the user as let say there is maybe 100 000 of them. same applies for the ID...</P><P></P><P>Then I'd like to find out the average per user as-well...</P><P></P><P>I am pretty sure it is straight forward, but not on a Friday...</P><P></P><P>Thank you,</P><P></P><P>Maxime</P></BODY></HTML> Fri, 01 Nov 2013 15:57:23 GMT https://community.qlik.com/t5/QlikView/A-Friday-Count/m-p/561782#M209666 2013-11-01T15:57:23Z Re: A Friday Count https://community.qlik.com/t5/QlikView/A-Friday-Count/m-p/561783#M209667 <HTML><HEAD></HEAD><BODY><P>#ofcalls: Count(distinct <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">User</SPAN>) </P><P>avgofcallsbyuser:&nbsp; avg(aggr(Count(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Call ID</SPAN>) ,<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">User</SPAN>))</P></BODY></HTML> Fri, 01 Nov 2013 16:05:10 GMT https://community.qlik.com/t5/QlikView/A-Friday-Count/m-p/561783#M209667 Clever_Anjos 2013-11-01T16:05:10Z Re: A Friday Count https://community.qlik.com/t5/QlikView/A-Friday-Count/m-p/561784#M209668 <HTML><HEAD></HEAD><BODY><P>Not if you want something</P></BODY></HTML> Fri, 01 Nov 2013 16:30:08 GMT https://community.qlik.com/t5/QlikView/A-Friday-Count/m-p/561784#M209668 2013-11-01T16:30:08Z