Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

association columns

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!


1 Solution

Accepted Solutions
rwunderlich
Not applicable

Re: association columns

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

2 Replies
rwunderlich
Not applicable

Re: association columns

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

Not applicable

Re: association columns

Thank you very much!