Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

LEFT JOIN

I have below two tables.

Purchase Order NumberSupplier IDQtyPart NOPriceTotal
101520SUP00125PART 00120500
101520SUP00125PART 00120500
Sales OrderCustomer IDPO NOQTYPart NO
5010Cust 00110152025PART 001
5011Cust 00210152025PART 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.

2 Replies
MVP
MVP

LEFT JOIN

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

kamalqlik
Valued Contributor

LEFT JOIN

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