Discussion board where members can get started with QlikView.
I' ve to combine data from different tables in this way:
First table: masterdata
Second tabel: purchase orders
Third Tabel: Purchase receivals
I've to provide a list of all suppliers starting from masterdata, with orders and receivals, but it's possible to have good receivals without orders or
purchase orders without receivals. For example, the supplier code 789, doesn't have any purchase order, but it's into a receival transaction, and I must
Is it possible ?
Thanks in advance for your help
Go to Solution.
Use outer join. Like this:
load * Inline [
outer join load * Inline [