topic Combine records with different keys in QlikView https://community.qlik.com/t5/QlikView/Combine-records-with-different-keys/m-p/259657#M1207998 <HTML><HEAD></HEAD><BODY><P>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).</P><P>And you should not load the ID, so that you can just group by employee name.</P><P>But note that you will have to make sure that employee names are unique,</P><P></P><P>Let me know if its not clear.</P></BODY></HTML> Wed, 26 May 2010 04:06:27 GMT boorgura 2010-05-26T04:06:27Z Combine records with different keys https://community.qlik.com/t5/QlikView/Combine-records-with-different-keys/m-p/259656#M1207997 <HTML><HEAD></HEAD><BODY><P>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.</P><P>I am a bit new to QlikView so any help would be much appreciated.</P></BODY></HTML> Wed, 26 May 2010 03:31:43 GMT https://community.qlik.com/t5/QlikView/Combine-records-with-different-keys/m-p/259656#M1207997 villegasi03 2010-05-26T03:31:43Z Combine records with different keys https://community.qlik.com/t5/QlikView/Combine-records-with-different-keys/m-p/259657#M1207998 <HTML><HEAD></HEAD><BODY><P>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).</P><P>And you should not load the ID, so that you can just group by employee name.</P><P>But note that you will have to make sure that employee names are unique,</P><P></P><P>Let me know if its not clear.</P></BODY></HTML> Wed, 26 May 2010 04:06:27 GMT https://community.qlik.com/t5/QlikView/Combine-records-with-different-keys/m-p/259657#M1207998 boorgura 2010-05-26T04:06:27Z Combine records with different keys https://community.qlik.com/t5/QlikView/Combine-records-with-different-keys/m-p/259658#M1207999 <HTML><HEAD></HEAD><BODY><P>Makes sense. Thank you for your assistance.</P></BODY></HTML> Wed, 26 May 2010 13:35:02 GMT https://community.qlik.com/t5/QlikView/Combine-records-with-different-keys/m-p/259658#M1207999 villegasi03 2010-05-26T13:35:02Z