topic association columns in App Development

association columns

Mon, 26 Jun 2017 19:08:52 GMT

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!

Re: association columns

rwunderlich — Tue, 27 Jun 2017 00:22:09 GMT

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

Re: association columns

Wed, 28 Jun 2017 07:31:27 GMT

Thank you very much!