Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for Data Integration and Data Analytics gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Champion
Champion

Removing Syn Key from Data Model

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

3 Replies
Highlighted
Champion
Champion

Re: Removing Syn Key from Data Model

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

Highlighted
Creator III
Creator III

Re: Removing Syn Key from Data Model

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

Highlighted
Contributor II
Contributor II

Re: Removing Syn Key from Data Model

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