Linking issue

Anonymous — Wed, 28 Oct 2015 14:03:47 GMT

I am tryng to create an exception report that matches Purchase orders & products between two sources

The first table has the felds:

[Purchase Order Number]

[Product]

[Quantity Received]

[Delivery Date]

The second table has:

[Purchase Order Number]

[Product]

[Quantity Sent]

[Request Date]

I have created a link field called %POProductKey which is the concatenation of [Purchase Order Number] and [Product]. I am not loading [Purchase Order Number] or [Product] from the first table to avoid synthetic keys.

The issue I have is if there is a %POProductKey in the first table that isn't in the second table it doesn't show the data for either in my exception report so both are 0 and it looks like there are no differences

Do I need to link the tables in a different way?

Thanks

topic Linking issue in QlikView

Linking issue