topic Re: Count unique values only in QlikView https://community.qlik.com/t5/QlikView/Count-unique-values-only/m-p/1035824#M938302 <HTML><HEAD></HEAD><BODY><P>May be one of these:</P><P></P><P><STRONG>Count(DISTINCT nr2)</STRONG></P><P></P><P>or</P><P></P><P><STRONG>Count(Aggr(Count(Distinct nr2), Class))</STRONG></P></BODY></HTML> Mon, 15 Feb 2016 12:07:43 GMT sunny_talwar 2016-02-15T12:07:43Z Count unique values only https://community.qlik.com/t5/QlikView/Count-unique-values-only/m-p/1035822#M938297 <HTML><HEAD></HEAD><BODY><P>Hello, I guess my question is very easy, still can't find solution..</P><P></P><P>I have table:</P><P>&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" width="128"><TBODY><TR><TD height="20" width="64">Class</TD><TD width="64">Nr2.</TD></TR><TR><TD height="20">LIRIKA</TD><TD>K000545</TD></TR><TR><TD height="20">LIRIKA</TD><TD>K000545</TD></TR><TR><TD height="20">LIRIKA</TD><TD>K000545</TD></TR><TR><TD height="20">LIRIKA</TD><TD>K000650</TD></TR><TR><TD height="20">LIRIKA</TD><TD>K000703</TD></TR><TR><TD height="20">LIRIKA</TD><TD>K000168</TD></TR><TR><TD height="20">LIRIKA</TD><TD>K000551</TD></TR></TBODY></TABLE><P></P><P></P><P>I need to get count of all unique Nr2 for each class.</P><P>I use Count(nr2) and get sum of all rows - the result is 7</P><P>But I need only count unique Nr2 .. and the result must be 5. How can I modify my COUNT?</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="font-size: 13.3333px; width: 128px;"><TBODY><TR><TD height="20" width="64">Class</TD><TD width="64">Nr2.</TD></TR><TR><TD height="20"></TD><TD></TD></TR><TR><TD height="20"></TD><TD></TD></TR><TR><TD height="20">LIRIKA</TD><TD>K000545</TD></TR><TR><TD height="20">LIRIKA</TD><TD>K000650</TD></TR><TR><TD height="20">LIRIKA</TD><TD>K000703</TD></TR><TR><TD height="20">LIRIKA</TD><TD>K000168</TD></TR><TR><TD height="20">LIRIKA</TD><TD>K000551</TD></TR></TBODY></TABLE></BODY></HTML> Mon, 15 Feb 2016 12:06:11 GMT https://community.qlik.com/t5/QlikView/Count-unique-values-only/m-p/1035822#M938297 sculptorlv 2016-02-15T12:06:11Z Re: Count unique values only https://community.qlik.com/t5/QlikView/Count-unique-values-only/m-p/1035823#M938299 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Try</P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Count(Distinct nr2) </SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Mark<BR /></SPAN></P></BODY></HTML> Mon, 15 Feb 2016 12:07:13 GMT https://community.qlik.com/t5/QlikView/Count-unique-values-only/m-p/1035823#M938299 Mark_Little 2016-02-15T12:07:13Z Re: Count unique values only https://community.qlik.com/t5/QlikView/Count-unique-values-only/m-p/1035824#M938302 <HTML><HEAD></HEAD><BODY><P>May be one of these:</P><P></P><P><STRONG>Count(DISTINCT nr2)</STRONG></P><P></P><P>or</P><P></P><P><STRONG>Count(Aggr(Count(Distinct nr2), Class))</STRONG></P></BODY></HTML> Mon, 15 Feb 2016 12:07:43 GMT https://community.qlik.com/t5/QlikView/Count-unique-values-only/m-p/1035824#M938302 sunny_talwar 2016-02-15T12:07:43Z Re: Count unique values only https://community.qlik.com/t5/QlikView/Count-unique-values-only/m-p/1035825#M938304 <HTML><HEAD></HEAD><BODY><P>use rownum()&nbsp; </P><P></P><P>or</P><P></P><P>count(distinct urfield)</P></BODY></HTML> Mon, 15 Feb 2016 12:08:13 GMT https://community.qlik.com/t5/QlikView/Count-unique-values-only/m-p/1035825#M938304 Chanty4u 2016-02-15T12:08:13Z Re: Count unique values only https://community.qlik.com/t5/QlikView/Count-unique-values-only/m-p/1035826#M938305 <HTML><HEAD></HEAD><BODY><P>Count(Distinct Nr2.)</P></BODY></HTML> Mon, 15 Feb 2016 12:10:18 GMT https://community.qlik.com/t5/QlikView/Count-unique-values-only/m-p/1035826#M938305 Anonymous 2016-02-15T12:10:18Z Re: Count unique values only https://community.qlik.com/t5/QlikView/Count-unique-values-only/m-p/1035827#M938306 <HTML><HEAD></HEAD><BODY><P>Thanks to all of you!</P></BODY></HTML> Mon, 15 Feb 2016 12:11:15 GMT https://community.qlik.com/t5/QlikView/Count-unique-values-only/m-p/1035827#M938306 sculptorlv 2016-02-15T12:11:15Z