Link from Fact table to Dimension on two different fields depending on the requirement

[bimanbeginner]

Hi There 

I have a requirement to link my fact table to my dimensions on two different keys, either the CompanyCodeFrom or the CompanyCodeTo depending on what the users need to see...  how would you best cater for this issue in Qlikview ? 

[abhijitnalekar]

HI @bimanbeginner ,

I will suggest you create an alias CompanyTable and create a model like below, and handle field switching logic on the application level.

[MarcoWedel]

this creates a loop in your data model

[MarcoWedel]

You can apply the principles that are described in this blog post as well:
https://community.qlik.com/t5/Qlik-Design-Blog/Canonical-Date/ba-p/1463578

hope this helps
Marco