Hope this resolve your issue. If the issue is solved please mark the answer with Accept as Solution & like it. If you want to go quickly, go alone. If you want to go far, go together.
key is nothing a way to connect tables in qlikview by same name,Link table is the process to remove synthetic keys and developing a good data model in Qlikview(Star Schema)
Lets suppose you have more than 3-4 tables with different Date field
Sales:
load Id,
SalesDate,
Country
from SalesTab;
Order:
Load OrderId,
OrderDate,
Product
from OrderTab;
Purchase:
Load ProductName,
InvoiceNo,
InvoiceDate
From PurchaseTab;
Here we have Three date field SalesDate,OrderDate and InvoiceDate,but we need only single date field to map all the dates for that we need a Link table with unique Key,suppose we dont have unique field value none of our table,for that we have to create composite key..
Like Below
Link Table:
Load Id&'-'& SalesDate as Key
SalesDate as Date
Resident Sales
concatenate
Load OrderId &'-'& OrderDate as Key1
OrderDate as Date
Resident Order;
concatenate
Load InvoiceNo &'-'& PurchaseDate as Key2
InvoiceDate as Date
Resident Purchase;
then now You get a star flake Data model with Link Table.
