topic Re: Unique count for Statistics Box in QlikView https://community.qlik.com/t5/QlikView/Unique-count-for-Statistics-Box/m-p/1094680#M464785 <HTML><HEAD></HEAD><BODY><P>Count(Distinct Field)</P></BODY></HTML> Tue, 12 Apr 2016 07:02:01 GMT 2016-04-12T07:02:01Z Unique count for Statistics Box https://community.qlik.com/t5/QlikView/Unique-count-for-Statistics-Box/m-p/1094677#M464782 <HTML><HEAD></HEAD><BODY><P>How can I get a unique count? I tried the Statistics box but this gave me a total count. I have a customer ID and their spend. Looking at the chart below, I just want to see how many unique customers I have. For example, below would be 3 unique customers (1234, 5678. 7890). I don't need their spend, just a count of how many customers.</P><P></P><P></P><P>&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" width="128"><TBODY><TR><TD class="xl63" height="20" width="64">ID</TD><TD class="xl63" style="border-left: none;" width="64">Spend</TD></TR><TR><TD align="right" class="xl63" height="20" style="border-top: none;">1234</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">$10 </TD></TR><TR><TD align="right" class="xl63" height="20" style="border-top: none;">1234</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">$10 </TD></TR><TR><TD align="right" class="xl63" height="20" style="border-top: none;">1234</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">$10 </TD></TR><TR><TD align="right" class="xl63" height="20" style="border-top: none;">5678</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">$10 </TD></TR><TR><TD align="right" class="xl63" height="20" style="border-top: none;">7890</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">$10 </TD></TR></TBODY></TABLE></BODY></HTML> Mon, 11 Apr 2016 14:59:41 GMT https://community.qlik.com/t5/QlikView/Unique-count-for-Statistics-Box/m-p/1094677#M464782 2016-04-11T14:59:41Z Re: Unique count for Statistics Box https://community.qlik.com/t5/QlikView/Unique-count-for-Statistics-Box/m-p/1094678#M464783 <HTML><HEAD></HEAD><BODY><P>May be this:</P><P></P><P><STRONG>Count(DISTINCT ID)</STRONG></P></BODY></HTML> Mon, 11 Apr 2016 15:42:19 GMT https://community.qlik.com/t5/QlikView/Unique-count-for-Statistics-Box/m-p/1094678#M464783 sunny_talwar 2016-04-11T15:42:19Z Re: Unique count for Statistics Box https://community.qlik.com/t5/QlikView/Unique-count-for-Statistics-Box/m-p/1094679#M464784 <HTML><HEAD></HEAD><BODY><P>=Count(Distinct Field)</P></BODY></HTML> Tue, 12 Apr 2016 06:21:13 GMT https://community.qlik.com/t5/QlikView/Unique-count-for-Statistics-Box/m-p/1094679#M464784 Chanty4u 2016-04-12T06:21:13Z Re: Unique count for Statistics Box https://community.qlik.com/t5/QlikView/Unique-count-for-Statistics-Box/m-p/1094680#M464785 <HTML><HEAD></HEAD><BODY><P>Count(Distinct Field)</P></BODY></HTML> Tue, 12 Apr 2016 07:02:01 GMT https://community.qlik.com/t5/QlikView/Unique-count-for-Statistics-Box/m-p/1094680#M464785 2016-04-12T07:02:01Z Re: Unique count for Statistics Box https://community.qlik.com/t5/QlikView/Unique-count-for-Statistics-Box/m-p/1094681#M464786 <HTML><HEAD></HEAD><BODY><P>Where to add "Count(Distinct Field)" as there is not "Expression tab" in Qlikview Statistics Box.</P></BODY></HTML> Thu, 16 Jun 2016 08:34:40 GMT https://community.qlik.com/t5/QlikView/Unique-count-for-Statistics-Box/m-p/1094681#M464786 Anonymous 2016-06-16T08:34:40Z