Explore and Learn Link Table Concept in

How to Create Link Table or Bridge Table to Resolve Synthetic Keys when multiple fact tables are present in the data model. Either we can use Concatenation or Link table Approach.
#dataintellinalytics #tutorial #qlikcloud #qliksaas #qlik #demo #qliksense #qlikview #training #dashboard #report #business #intelligence

[@BenMcKenna-zn9yj]

Thank you for this! This is my exact situation. So would you say that this is the best way to create relationships when you have two fact tables with multiple dimensions in common?

[@DatAIntellinalytics]

Yes correct, another option is to concatenate Fact Tables provided the Granularity is same.

[@KunalKumar-n8s6x]

i have fact tables in which data modeling based on order date but user want in my fact table there is other column which has delivery date user want when i select jan then it gives delivery orders in that month but my data modelling made on order date, i also made link table but it didn't work . can you guide me

[@DatAIntellinalytics]

Either you convince the business and have two separate Date Filters OR You have to use Canonical Date method to get common date filter. You can refer community.qlik.com/t5/Design/Canonical-Date/ba-p/1463578

[@zirvashami9781]

I am trying to link tables by making these keys but my field names from different tables are not the same. I try to make them same by creating aliases but Qlik doesn't recognise the aliases. Eg, the different fields in tables are Product, Products, & PRODUCT. How to link tables in this scenario? Any help will be highly appreciated.

[@DatAIntellinalytics]

please share a snapshot or your actual code for better understanding.