Discussion Board for collaboration on QlikView Scripting.
I have a model which includes 2 tables: Orders, and invoices.
Not all invoices would reference to an order, and not all orders would have an invoice.
The orders have the following fields:
The invoices table has the following fields:
What would be the best way to link between the 2 tables so an item analysis can be performed for both?
Thanks in Advance!
Go to Solution.
I would concatenate the order and invoice data to a single table.
Is the Order Qty and Invoice Qty the same for a matching OrderId & ItemId? If yes, then you only need on Qty field, if not then you will need to rename the fields as OrderQty and InvQty.
Try something like
OrdID, OrdDate, CustID, ItemID, Qty as OrderQty
from <Your Order Source> ;
InvDate , OrdID, ItemID, Qty as InvQty