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, ...
Get QlikView for Developers Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
