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?
Because it will form a loop, which will result in wrong calculations hence the use of Link Table. Imagine Dim A and Dim B both linked to both Fact 1 and Fact2, it will form a circular loop.
Thank you very much for taking time to reply. You have been very kind. but I don’t think it will be circular. As I said, conformed dimensions are modeled that way but I am sure I am missing something here.
Simple POC with dummy dataset should clear your doubts please give a try. Also You cannot do apple to apple comparison between Qlik data modeling and traditional RDBMS modeling.
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
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
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.
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?
Yes correct, another option is to concatenate Fact Tables provided the Granularity is same.
how are conformed dimensions modeled? can you please explain why 1 dimension cannot be related to 2 or more facts?
Because it will form a loop, which will result in wrong calculations hence the use of Link Table. Imagine Dim A and Dim B both linked to both Fact 1 and Fact2, it will form a circular loop.
Thank you very much for taking time to reply. You have been very kind. but I don’t think it will be circular. As I said, conformed dimensions are modeled that way but I am sure I am missing something here.
Simple POC with dummy dataset should clear your doubts please give a try. Also You cannot do apple to apple comparison between Qlik data modeling and traditional RDBMS modeling.
I see. I get it now. Thanks for your quick response
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
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
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.
please share a snapshot or your actual code for better understanding.