See the example.
I have two tables: Purchasing and Sales.
I use a link table to select the fields that are used in both tables.
My English is poor and it is difficult to explain.
Hope this helps.
TableLink.qvw 157.5 K
You don't required to link twok tables. Qlikview will automatically link two tables if there is matching column in both tables.
Note: If there is more than one matching column, you will get synthetic keys. Synthetic keys should avoid in qlikview. We can avoid synthetic keys by renaming the fields.
Hope it helps you..