Best way for Linking tables

Sat, 03 Jan 2015 12:04:42 GMT

Hi,

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:

OrdID

OrdDate

CustID

ItemID

Qty

The invoices table has the following fields:

InvID

InvDate

OrdID

ItemID

Qty

What would be the best way to link between the 2 tables so an item analysis can be performed for both?

Thanks in Advance!

Re: Best way for Linking tables

Colin-Albert — Sat, 03 Jan 2015 13:16:40 GMT

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

Orders:

load

     OrdID,
     OrdDate,
     CustID,
     ItemID,
     Qty as OrderQty

from <Your Order Source> ;

concatenate(Orders)

load

InvID,

     InvDate ,
     OrdID,
     ItemID,
     Qty as InvQty

from <Your Order Source> ;

topic Re: Best way for Linking tables in QlikView

Best way for Linking tables

Re: Best way for Linking tables