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
      1111

      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.