topic Linking two fields in QlikView https://community.qlik.com/t5/QlikView/Linking-two-fields/m-p/146220#M24816 <HTML><HEAD></HEAD><BODY><P>I have two separate spreadsheets. One with just the EmployeeName and EmployeeID. The other lists the sales each employee made but that one only has EmpID (which is the Employee's ID numbers). How do I link the EmpID from the Sales spreadsheet to the EmployeeID in the Employee Spreadsheet so that selecting the Employee's name will automatically find that employee's sales through his or her ID number?</P><P>I'm loading the data through ODBC from two Excel spreadsheets.</P><P>Thanks</P></BODY></HTML> Tue, 09 Jun 2009 11:38:48 GMT 2009-06-09T11:38:48Z Linking two fields https://community.qlik.com/t5/QlikView/Linking-two-fields/m-p/146220#M24816 <HTML><HEAD></HEAD><BODY><P>I have two separate spreadsheets. One with just the EmployeeName and EmployeeID. The other lists the sales each employee made but that one only has EmpID (which is the Employee's ID numbers). How do I link the EmpID from the Sales spreadsheet to the EmployeeID in the Employee Spreadsheet so that selecting the Employee's name will automatically find that employee's sales through his or her ID number?</P><P>I'm loading the data through ODBC from two Excel spreadsheets.</P><P>Thanks</P></BODY></HTML> Tue, 09 Jun 2009 11:38:48 GMT https://community.qlik.com/t5/QlikView/Linking-two-fields/m-p/146220#M24816 2009-06-09T11:38:48Z Linking two fields https://community.qlik.com/t5/QlikView/Linking-two-fields/m-p/146221#M24817 <HTML><HEAD></HEAD><BODY><P>Nevermind I found a solution already.</P></BODY></HTML> Tue, 09 Jun 2009 11:49:59 GMT https://community.qlik.com/t5/QlikView/Linking-two-fields/m-p/146221#M24817 2009-06-09T11:49:59Z