Creating a Key/Link table in QlikView

Where there are fact tables that mostly share a set of keys, concatenation should always be considered first. However, where there are many more keys in one fact table than another, and the additional keys are not relevant to the second table, it may be a better approach to create a key table to link the common keys.

In this recipe, we are going to create a budget for store and product but not put any date on this.

Getting ready

Load the following script:

Store:
Load * Inline [
StoreID, StoreName
1, Store A
2, Store B
];

Calendar:
Load MonthID As DateID, Month Inline [
MonthID, Month
1, Jan
2, Feb
];

Product:
Load * Inline [
ProductID, Product
1, Product A
2, Product B
];

Sales:
LOAD * INLINE [
    DateID, StoreID, ProductID, SaleQty, SaleValue
    1, 1, 1, 2, 23
    1, 1, 2, 4, 24
    2, 1, 1, 4, 33
    2, 1, 2, 3, 28
    1, 2, 1, 2, 21
    1, 2, 2, 4, 30
    2, 2, 1, 3, 25
];

Budget:
LOAD * INLINE [
    StoreID, ProductID, BudgetQty, BudgetValue...