topic Help: How to link these table up? in QlikView

Help: How to link these table up?

Fri, 19 Aug 2011 09:49:14 GMT

I believe this probably a very easy question to all of you but I don't really know how to do because the output is not what I want.

I have a Sales Table, Customer Table and a Sales Revenue Table. I tried to link these up, looks easy but I couldn't get what I want after.

Anyone can help me a bit?

Many thanks

Please refer to the attached qvw file.

Problem: A dedicated salesperson will look after a customer but another salesperson can do business with other customer as well. In such case, I would like to see how much sales amount of a customer to the company and by whom. I linked up all table and create a pivot table, found that if the sales is not done by the responsible salesperson, the customer's name unable to be shown. How can i solve this? any problem with my tables structure?

Help: How to link these table up?

sushil353 — Fri, 19 Aug 2011 09:56:38 GMT

Please be more clear with your problem...

Help: How to link these table up?

sushil353 — Fri, 19 Aug 2011 10:02:57 GMT

try this while loading..

qualify *;

unqualify salespersonid;

Load * from customer;

unqulify *;

load * from sales revenue;

load * from sales;

Hope it will help

Re: Help: How to link these table up?

gandalfgray — Fri, 19 Aug 2011 10:52:21 GMT

Hi lihhlihh!

Do not rename ResponsibleSalesID in the first load statement.

Then you need to add a fourth load statement (to get the names for the ResponsibleSales persons, like this:

LOAD SalesPersonID As ResponsibleSalesID,

SalesPersonName As ResponsibleSalesPersonName

FROM

(biff, embedded labels, table is Salesperson$);

hth/gg