Discussion board where members can get started with QlikView.
I have 2 fact tables with date and master calender . I wanted to link 2 fact tables with Master calender using Calderday date field
can anyone guide how to link this 2 fact with one master calender
Usually, you can use a Concatenation, to just concatenate these 2 Fact tables to have one physical Fact connected with your Master Calendar.
Find attached the modified Script, you can see the concatenation just after the Load of the second Fact table.
You can combine two key fields like Key&CalendarDay as NewKey
or using autonumber function for generate new key from two fields key autonumber( Key&CalendarDay) as NewKey
after that, remove two fileds Key,CalendarDay from RSP tables or FactSales base on requirement
Synthetic keys ‒ Qlik Sense
Hii Vikas Mahajan,
You should Use LinkTable Concept For This,
First create Composite Key in both Fact Tables
Then Create a Period Key in Master Calendar
and Keep this two keys in LinkTable.