topic Re: Duplicate Employees?? in QlikView

Duplicate Employees??

pablomind — Mon, 22 Feb 2016 09:38:10 GMT

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???

Re: Duplicate Employees??

kaushiknsolanki — Mon, 22 Feb 2016 10:41:34 GMT

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

Re: Duplicate Employees??

sunny_talwar — Mon, 22 Feb 2016 10:41:45 GMT

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

Re: Duplicate Employees??

tresB — Mon, 22 Feb 2016 10:42:13 GMT

May be like:

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

Re: Duplicate Employees??

pablomind — Mon, 22 Feb 2016 10:45:43 GMT

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