Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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
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
Thank you very much!