topic Re: explicitly assigning foreign key for a table? in QlikView

explicitly assigning foreign key for a table?

Thu, 13 Mar 2014 10:38:43 GMT

Hi Experts,

Here is my question.

Below is a table called 'DimDate' table. In this table, 'DateKey' acts as an ID column and remaining are other additional columns.

DimDate
Datekey
Date
Month
Day
Year
Time

Below is another table called 'FactSales' table. As we see, there are three columns, ShipDateKey, OrderDateKey, and DueDateKey, which are supposed to be the 'DateKey' from the DimDate table as above..

FactSales
FactSalesID
ShipDateKey
OrderDateKey
DueDateKey
Amount
Product ID

Qlikview is not recognizing this association as the column names in the FactSales table are different from the one in the DimDate table for Key field.

How do we get this association done right? Is it possible to achieve it.

Please kindly guide me.

Thank you.

Re: explicitly assigning foreign key for a table?

amit_saini — Thu, 13 Mar 2014 10:44:43 GMT

Hi Pramod,

You can rename 'ShipDateKey' as DateKey while calling FactSales Table. Similarly, you can do with OrderDateKey or DueDateKey depending upon you requirement.

Thanks,
AS

Re: explicitly assigning foreign key for a table?

Thu, 13 Mar 2014 10:46:02 GMT

You need to determine which of the DateKeys in the 2nd table matches the DimDate table datekey, then (for example) in the Fact table load statement

ShipDateKey AS DateKey

Re: explicitly assigning foreign key for a table?

Thu, 13 Mar 2014 10:48:14 GMT

You need to join the Dimension table three time to find the respective date. First load the facttable and then load dimension table like Datekey as ShipDateKey, date as Shipdate. And load the dimension table again like Datekey as OrderDateKey, date as Ordrdate.