Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
pablomind
Creator
Creator

Duplicate Employees??

I need help with this: I need to know how many duplicates (employees) I have based in if they have the same Last Name and Date of Birth but different ID then count it. Any suggestion?

So far I had this:

= Sum(Aggr(If(Count(Last_Name)>1,1,0),Date_Birth))

But is not working right... Should I also make another Aggr of Employee_ID???

1 Solution

Accepted Solutions
pablomind
Creator
Creator
Author

Thank you for your suggestions. At the end I could solved it doing this:

= Sum(Aggr(If(Count(ID)>1,1,0),Date_Birth,Last_Name))

View solution in original post

4 Replies
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Do one thing.

Create a chart with Employee Name and Date of Birth

And expression as Count(Distinct EmployeeID)

Ans sort the data by 'Y' value.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
sunny_talwar

May be create a calculated Dimension:

[Last Name] &  ' ' & Date([Date of Birth])

and Expression: Concat(ID, ', ') to know the ID's associated with each of the combination

or Count(ID) to know how many IDs are associated with each combination

tresesco
MVP
MVP

May be like:

Sum(Aggr(If(Count(Last_Name)>1,1,0),ID,Date_Birth))

pablomind
Creator
Creator
Author

Thank you for your suggestions. At the end I could solved it doing this:

= Sum(Aggr(If(Count(ID)>1,1,0),Date_Birth,Last_Name))