Combine records with different keys

[villegasi03]

I am building a dashboard that shows employee sales and performance. When I brought in the employee table for the first time I noticed that the same employees are listed multiple times with different IDs. Is there something I can do to clean that up in the load script. Since sales are linked to the employee ID, it will need to be able to relate all sales for the one employee listed under two different IDs.

I am a bit new to QlikView so any help would be much appreciated.

[boorgura · Accepted solution]

If all you need is to sum up the Sales per employee name and not ID - you will have load the name and Sum(Sales).

And you should not load the ID, so that you can just group by employee name.

But note that you will have to make sure that employee names are unique,

Let me know if its not clear.

[villegasi03]

Makes sense. Thank you for your assistance.