topic LEFT JOIN in QlikView

LEFT JOIN

Thu, 27 Oct 2011 15:22:24 GMT

I have below two tables.

Purchase Order Number	Supplier ID	Qty	Part NO	Price	Total
101520	SUP001	25	PART 001	20	500
101520	SUP001	25	PART 001	20	500

Sales Order	Customer ID	PO NO	QTY	Part NO
5010	Cust 001	101520	25	PART 001
5011	Cust 002	101520	25	PART 001

Table 1 is having purchase data while table two is having sales data.

Both table have many other columns but don't required in this question so I have ignored them.

1st table is linked with 2nd table with Left Join.

Both tables have more than 10000 lines. Just two lines are shown for which I have problem.

Question is.... I need Customer ID against my purchase table data. But due to Purchase Order Number, SUPPLIER ID, PART NUMBER and QTY all are same, chart/table in QlikView is confused which line is for which customer.

Is there any function/method, so that both lines are giving different customer ID?

Thanks in advance.

LEFT JOIN

swuehl — Thu, 27 Oct 2011 16:08:37 GMT

mrkachhia,

I don't believe there's a way to do that using a join (at least if you use only the shown fields).

The important thing would be to know how you handle this in your business, i.e. how do you decide in your real business which record of your purchase table belongs to which customer. Then it might be possible to tell QV what to do (Maybe by adding a new field to both tables indicating an order of records, if fields used to join have the same values for multiple records, but are not really duplicates for all fields).

Regards,

Stefan

LEFT JOIN

kamalqlik — Fri, 28 Oct 2011 04:21:44 GMT

Hi,

I think that you must have a unique field that may differentiate between the two tables.You must ask with the business user ,because qlikview will not be able to differentiate