Removing Syn Key from Data Model - Qlik Community

vikasmahajan · ‎2017-10-06

Hi all

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

Thanks

Vikas

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.

YoussefBelloum · ‎2017-10-06

Hi,

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.

YB

kenphamvn · ‎2017-10-06

Hi

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

Regards,

An Pham

Anonymous · ‎2017-10-06

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.

Regards,

Akash Gaikwad