4 Replies Latest reply: Apr 13, 2018 10:00 AM by Jorge Yanez RSS

    Associating Column From 2 Excel Files

    Jorge Yanez

      Hello everyone,


      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. 

      EmployeeIDEmployee Name

      John Smith



      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.