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
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.