Discussion board where members can learn more about Qlik Sense App Development and Usage.
I have these tables in excel:
Product manager is salesman
How can I make a table in qlik sense to display:
City | the product sold | Who is the product manager | Who sold it |
Roma | Product 1 | Joey | Billy
Paris | Product 2 | Joey | Joey
Berlin | Product 4 | Billy | Joey
Madrid | Product 3 | Billy | Elis
Go to Solution.
Here's a suggestion. Sample qvf attached. lib://thread is defined in the sample qvf and points to this thread.
ID as ID_Salesman,
(html, codepage is 1252, embedded labels, table is @1);
ID as ID_Manager,
Salesman as Product_manager
LOAD ID as ID_Product,
Product_manager as ID_Manager
(html, codepage is 1252, embedded labels, table is @2);
LOAD ID as ID_Sold,
(html, codepage is 1252, embedded labels, table is @3);
Thank you very much!