association columns

[#1]

Hello,

I have these tables in excel:

ID	Salesman
1	Joey
2	Elis
3	Billy

ID	Product	Product_manager
1	Product 1	1
2	Product 2	1
3	Product 3	3
4	Product 4	3

Product manager is salesman

ID	City	ID_Product	ID_Salesman
1	Roma	1	3
2	Paris	2	1
3	Berlin	2	1
4	Madrid	3	2

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!

[rwunderlich · Accepted solution]

Here's a suggestion. Sample qvf attached. lib://thread is defined in the sample qvf and points to this thread.

SalesRep:

LOAD

  ID as ID_Salesman,

    Salesman

FROM

[lib://thread]

(html, codepage is 1252, embedded labels, table is @1);

Manager:

LOAD

  ID as ID_Manager,

    Salesman as Product_manager

FROM

[lib://thread]

(html, codepage is 1252, embedded labels, table is @1);

Products:

LOAD ID as ID_Product,

    Product,

    Product_manager as ID_Manager

FROM

[lib://thread]

(html, codepage is 1252, embedded labels, table is @2);

Sold:

LOAD ID as ID_Sold,

    City,

    ID_Product,

    ID_Salesman

FROM

[lib://thread]

(html, codepage is 1252, embedded labels, table is @3);

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

[#3]

Thank you very much!