2 Replies Latest reply: Jun 28, 2017 3:31 AM by Capatina Sterica RSS

    association columns

    Capatina Sterica

      Hello,

      I have these tables in excel:

        

      IDSalesman
      1Joey
      2Elis
      3Billy

         

      IDProductProduct_manager
      1Product 11
      2Product 21
      3Product 33
      4Product 43

      Product manager is salesman

        

      IDCityID_ProductID_Salesman
      1Roma13
      2Paris21
      3Berlin21
      4Madrid32

       

      How can I make a table in qlik sense to display:

      City | the product sold | Who is the product manager | Who sold it |


      Example:

      Roma   | Product 1 | Joey | Billy

      Paris    | Product 2 | Joey | Joey

      Berlin   | Product 4 | Billy | Joey

      Madrid | Product 3 | Billy  | Elis


      Thank you!