Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ali_hijazi
Partner
Partner

schema for multiple facts

Hello got multiple fact tables
I want to create a linktable / bridge table to link them together and thus create a schema
what are the rules in this case?
how do I choose the keys from each fact table and how to link them in the link table?
kindly advise

I can walk on water when it freezes
3 Replies
stevejoyce
Creator III
Creator III

Your link table has all common fields between your fact tables (example dimension foreign keys).  Fact tables only contain the unique fields.  The rest of your data model associates to the link table.

If your fact tables are similar in structure, you can choose to concatenate (union) fact tables instead of a link table.

ali_hijazi
Partner
Partner
Author

So you mean fact tables link to the bridge table via the unique keys of each row or not necessarily?

 

I can walk on water when it freezes
stevejoyce
Creator III
Creator III

Yes.  You'll need to add appropriate keys to the link table to associate to each fact, or create composite keys for each table with appropriate fields in qlik.  It's essentially a synthetic table that qlik auto generates in this scenario.

Take a look at this post:

https://community.qlik.com/t5/Qlik-Design-Blog/Fact-Table-with-Mixed-Granularity/ba-p/1468238