topic Re: Link from Fact table to Dimension on two different fields depending on the requirement in QlikView

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

bimanbeginner — Tue, 19 Oct 2021 07:57:39 GMT

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 ?

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

abhijitnalekar — Wed, 20 Oct 2021 12:01:33 GMT

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.

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

MarcoWedel — Wed, 20 Oct 2021 21:04:54 GMT

this creates a loop in your data model

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

MarcoWedel — Wed, 20 Oct 2021 21:11:39 GMT

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