topic Re: How can I count a doc number? in QlikView https://community.qlik.com/t5/QlikView/How-can-I-count-a-doc-number/m-p/372160#M138388 <HTML><HEAD></HEAD><BODY><P>Hi Craig,</P><P></P><P>try COUNT(<STRONG>DISTINCT </STRONG>Document Number)</P><P></P><P>Regards, Jakob</P></BODY></HTML> Thu, 28 Jun 2012 08:52:38 GMT jjfabian 2012-06-28T08:52:38Z How can I count a doc number? https://community.qlik.com/t5/QlikView/How-can-I-count-a-doc-number/m-p/372159#M138387 <HTML><HEAD></HEAD><BODY><P>Apologies for any protocol error, this is my first post.</P><P></P><P>I have a list of document numbers and users, and I want to show the number of documents per user.</P><P></P><P>I have made a pivot table with users and COUNT(Document Number)</P><P></P><P>But I have hit a stumbling block, many of the document numbers count as more than one, some of them have hundreds of occurences because of the number of lines in the document.</P><P></P><P>Is there an easy way to count each document number only once?</P></BODY></HTML> Thu, 28 Jun 2012 08:50:53 GMT https://community.qlik.com/t5/QlikView/How-can-I-count-a-doc-number/m-p/372159#M138387 2012-06-28T08:50:53Z Re: How can I count a doc number? https://community.qlik.com/t5/QlikView/How-can-I-count-a-doc-number/m-p/372160#M138388 <HTML><HEAD></HEAD><BODY><P>Hi Craig,</P><P></P><P>try COUNT(<STRONG>DISTINCT </STRONG>Document Number)</P><P></P><P>Regards, Jakob</P></BODY></HTML> Thu, 28 Jun 2012 08:52:38 GMT https://community.qlik.com/t5/QlikView/How-can-I-count-a-doc-number/m-p/372160#M138388 jjfabian 2012-06-28T08:52:38Z Re: How can I count a doc number? https://community.qlik.com/t5/QlikView/How-can-I-count-a-doc-number/m-p/372161#M138389 <HTML><HEAD></HEAD><BODY><P>It works, thank you for your help Jakob.</P></BODY></HTML> Thu, 28 Jun 2012 08:59:15 GMT https://community.qlik.com/t5/QlikView/How-can-I-count-a-doc-number/m-p/372161#M138389 2012-06-28T08:59:15Z