topic How to DistinctCount? in QlikView https://community.qlik.com/t5/QlikView/How-to-DistinctCount/m-p/435527#M162420 <HTML><HEAD></HEAD><BODY><P>Hello</P><P></P><P>I have a fact table including answers to a survey by employee.</P><P>I have an expression =COUNT(EmploiyeeID) which will give me # of answers.Answers is the most granular level, so for a given EmployeeID I might have up to 5 records, which makes up to 5 EmployeeIDs (same EmployeeID).</P><P></P><P>In my solution, I would like to count number of Employees and not answers.</P><P></P><P>So If I count 5 "answers" I would like to have a metric giving 1 "employee".</P><P></P><P>Is there a way to accumplish this?</P><P></P><P>Thanks in advance</P></BODY></HTML> Sat, 20 Oct 2012 20:12:22 GMT 2012-10-20T20:12:22Z How to DistinctCount? https://community.qlik.com/t5/QlikView/How-to-DistinctCount/m-p/435527#M162420 <HTML><HEAD></HEAD><BODY><P>Hello</P><P></P><P>I have a fact table including answers to a survey by employee.</P><P>I have an expression =COUNT(EmploiyeeID) which will give me # of answers.Answers is the most granular level, so for a given EmployeeID I might have up to 5 records, which makes up to 5 EmployeeIDs (same EmployeeID).</P><P></P><P>In my solution, I would like to count number of Employees and not answers.</P><P></P><P>So If I count 5 "answers" I would like to have a metric giving 1 "employee".</P><P></P><P>Is there a way to accumplish this?</P><P></P><P>Thanks in advance</P></BODY></HTML> Sat, 20 Oct 2012 20:12:22 GMT https://community.qlik.com/t5/QlikView/How-to-DistinctCount/m-p/435527#M162420 2012-10-20T20:12:22Z Re: How to DistinctCount? https://community.qlik.com/t5/QlikView/How-to-DistinctCount/m-p/435528#M162421 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>Try like this</P><P>=Count(Distinct EmployeeID)</P><P>Hope it helps</P></BODY></HTML> Sat, 20 Oct 2012 22:41:26 GMT https://community.qlik.com/t5/QlikView/How-to-DistinctCount/m-p/435528#M162421 MayilVahanan 2012-10-20T22:41:26Z