Discussion board where members can get started with Qlik Sense.
I am fairly new to Qlik and am just trying it out. Ive been watching some tutorials on Youtube but got stuck on the following.
I am working with two different Excel files.
File 1: Simple excel with 2 columns, one with employee ID and the other with a name.
File 2: List of Sales, Product ID, but ONLY employee ID, no employee name.
How can associate these two variables so i can determine which employee sold the most?
Thank you in advance.
If you make sure that your Employee ID field has the same name in both tables then Qlik should automatically link the 2 tables via that field. Then you can just bring in the fields as needed.
Hope that works for you.
You right about field name must be same name and but in that value of both fields must be same then associate property will work.
(ooxml, embedded labels, table is [Sheet1]);
List of Sales,
Applymap('MAP_Name',EmployeeID,'NA') As Name
Thanks for the replies Interesting, seems I have a lot to learn (too much)