topic Re: Link table with different dimensions for different Facts in QlikView https://community.qlik.com/t5/QlikView/Link-table-with-different-dimensions-for-different-Facts/m-p/1586749#M628056 <P>Oleg, can you go into a bit more detail on why two combo keys are necessary, as opposed to a single key?</P> Thu, 30 May 2019 15:53:32 GMT federerman 2019-05-30T15:53:32Z Link table with different dimensions for different Facts https://community.qlik.com/t5/QlikView/Link-table-with-different-dimensions-for-different-Facts/m-p/1212485#M628051 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I am trying to find out if it is possible to create a link table which will have 2 Fact tables with similar dimensions and keys, while the third Fact will not have the same set of dimension keys. is it possible to create a separate composite key just to connect the fact2 and fact3? Or is it possible to use the same key created for the Fact1 and 2 for joining Fact3 as well.</P><P></P><P><IMG alt="LinkTable.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/141711_LinkTable.JPG" style="height: auto;" /></P><P>Thanks.</P></BODY></HTML> Mon, 24 Oct 2016 14:12:57 GMT https://community.qlik.com/t5/QlikView/Link-table-with-different-dimensions-for-different-Facts/m-p/1212485#M628051 2016-10-24T14:12:57Z Re: Link table with different dimensions for different Facts https://community.qlik.com/t5/QlikView/Link-table-with-different-dimensions-for-different-Facts/m-p/1212486#M628053 <HTML><HEAD></HEAD><BODY><P>Yes, you can create a Link Table that connects different Facts with difference granularity levels. You will need to generate two Combo keys - one with all three common keys and another one with only the two common keys. Fact1 and Fact2 will be joined by the first key, while Fact3 will be joined by the second key.</P><P></P><P>I'm describing this kind of a data model with a lot of detail in my book <A href="http://www.amazon.com/gp/product/1118949552/ref=as_li_tl?ie=UTF8&amp;camp=1789&amp;creative=9325&amp;creativeASIN=1118949552&amp;linkCode=as2&amp;tag=natursyner0f-20&amp;linkId=CVZRHMG6CVR2FGTA">QlikView Your Business</A>.</P><P></P><P>cheers,</P><P>OlegTroyansky</P></BODY></HTML> Mon, 24 Oct 2016 15:37:49 GMT https://community.qlik.com/t5/QlikView/Link-table-with-different-dimensions-for-different-Facts/m-p/1212486#M628053 Oleg_Troyansky 2016-10-24T15:37:49Z Re: Link table with different dimensions for different Facts https://community.qlik.com/t5/QlikView/Link-table-with-different-dimensions-for-different-Facts/m-p/1212487#M628054 <HTML><HEAD></HEAD><BODY><P>Hi Oleg,</P><P>could you please help me creating a link table.</P><P></P><P>Hi have:</P><P></P><P>T1:</P><P>ID_T</P><P>...</P><P></P><P>T2:</P><P>ID_A</P><P>ID_T</P><P>...</P><P></P><P>T3:</P><P>ID_R</P><P>ID_A</P><P>...</P><P></P><P>T4:</P><P>ID_R</P><P>ID_T</P><P>...</P><P></P><P>T5:</P><P>ID_R</P><P></P><P>I found big problems creating my Link Table.</P><P>I tried many times in different ways but no results.</P><P>Could you please help me</P><P></P><P>best regards</P><P>Giampiero</P></BODY></HTML> Tue, 22 Nov 2016 14:09:04 GMT https://community.qlik.com/t5/QlikView/Link-table-with-different-dimensions-for-different-Facts/m-p/1212487#M628054 jampierre 2016-11-22T14:09:04Z Re: Link table with different dimensions for different Facts https://community.qlik.com/t5/QlikView/Link-table-with-different-dimensions-for-different-Facts/m-p/1586749#M628056 <P>Oleg, can you go into a bit more detail on why two combo keys are necessary, as opposed to a single key?</P> Thu, 30 May 2019 15:53:32 GMT https://community.qlik.com/t5/QlikView/Link-table-with-different-dimensions-for-different-Facts/m-p/1586749#M628056 federerman 2019-05-30T15:53:32Z