topic Count unique records in QlikView https://community.qlik.com/t5/QlikView/Count-unique-records/m-p/912968#M316758 <HTML><HEAD></HEAD><BODY><P><SPAN lang="en">Hello,<BR />this is an example of what I need.</SPAN></P><P><SPAN lang="en"><BR /></SPAN></P><P><SPAN lang="en">I need to count the first time that a concrete ID appears. If an ID appears twice I only want it to be counted once.</SPAN></P><P><SPAN lang="en"><BR /></SPAN></P><P><SPAN lang="en">Can you help me?<BR /></SPAN></P><P><SPAN lang="en">thanks<BR /></SPAN></P><P><SPAN lang="en"><BR /></SPAN></P></BODY></HTML> Thu, 23 Jul 2015 21:10:26 GMT 2015-07-23T21:10:26Z Count unique records https://community.qlik.com/t5/QlikView/Count-unique-records/m-p/912968#M316758 <HTML><HEAD></HEAD><BODY><P><SPAN lang="en">Hello,<BR />this is an example of what I need.</SPAN></P><P><SPAN lang="en"><BR /></SPAN></P><P><SPAN lang="en">I need to count the first time that a concrete ID appears. If an ID appears twice I only want it to be counted once.</SPAN></P><P><SPAN lang="en"><BR /></SPAN></P><P><SPAN lang="en">Can you help me?<BR /></SPAN></P><P><SPAN lang="en">thanks<BR /></SPAN></P><P><SPAN lang="en"><BR /></SPAN></P></BODY></HTML> Thu, 23 Jul 2015 21:10:26 GMT https://community.qlik.com/t5/QlikView/Count-unique-records/m-p/912968#M316758 2015-07-23T21:10:26Z Re: Count unique records https://community.qlik.com/t5/QlikView/Count-unique-records/m-p/912969#M316759 <HTML><HEAD></HEAD><BODY><P>Sorry, it's absolutely unclear to me looking at your description and the qvw what you are trying to achieve. Please describe your requirements a bit more detailed, best with some sample results you want to obtain from your data set.</P></BODY></HTML> Thu, 23 Jul 2015 22:47:09 GMT https://community.qlik.com/t5/QlikView/Count-unique-records/m-p/912969#M316759 swuehl 2015-07-23T22:47:09Z Re: Count unique records https://community.qlik.com/t5/QlikView/Count-unique-records/m-p/912970#M316760 <HTML><HEAD></HEAD><BODY><P>if you want only unique id count add expression similar to below:</P><P></P><P>Count(Distinct(ID))</P></BODY></HTML> Fri, 24 Jul 2015 04:32:52 GMT https://community.qlik.com/t5/QlikView/Count-unique-records/m-p/912970#M316760 vardhancse 2015-07-24T04:32:52Z