Solved: How to DistinctCount? - Qlik Community

Report Inappropriate Content · ‎2012-10-20

Hello

I have a fact table including answers to a survey by employee.

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).

In my solution, I would like to count number of Employees and not answers.

So If I count 5 "answers" I would like to have a metric giving 1 "employee".

Is there a way to accumplish this?

Thanks in advance

MayilVahanan · ‎2012-10-20

Hi

Try like this

=Count(Distinct EmployeeID)

Hope it helps

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

View solution in original post

MayilVahanan · ‎2012-10-20

Hi

Try like this

=Count(Distinct EmployeeID)

Hope it helps

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.