topic How to avoid synthetic table creation and circular references. in QlikView https://community.qlik.com/t5/QlikView/How-to-avoid-synthetic-table-creation-and-circular-references/m-p/417730#M559160 <HTML><HEAD></HEAD><BODY><P>Hi everyone ,</P><P></P><P>If I have 2 fact tables that need to be connected to two same dimensions. In this scenario how can I avoid creation of synthetic tables and circular references.</P><P></P><P></P><P>Thanks.</P></BODY></HTML> Wed, 29 May 2013 08:08:25 GMT 2013-05-29T08:08:25Z How to avoid synthetic table creation and circular references. https://community.qlik.com/t5/QlikView/How-to-avoid-synthetic-table-creation-and-circular-references/m-p/417730#M559160 <HTML><HEAD></HEAD><BODY><P>Hi everyone ,</P><P></P><P>If I have 2 fact tables that need to be connected to two same dimensions. In this scenario how can I avoid creation of synthetic tables and circular references.</P><P></P><P></P><P>Thanks.</P></BODY></HTML> Wed, 29 May 2013 08:08:25 GMT https://community.qlik.com/t5/QlikView/How-to-avoid-synthetic-table-creation-and-circular-references/m-p/417730#M559160 2013-05-29T08:08:25Z Re: How to avoid synthetic table creation and circular references. https://community.qlik.com/t5/QlikView/How-to-avoid-synthetic-table-creation-and-circular-references/m-p/417731#M559161 <HTML><HEAD></HEAD><BODY><P>use concatenate instead. join both into one fact table.</P></BODY></HTML> Wed, 29 May 2013 08:12:44 GMT https://community.qlik.com/t5/QlikView/How-to-avoid-synthetic-table-creation-and-circular-references/m-p/417731#M559161 2013-05-29T08:12:44Z Re: How to avoid synthetic table creation and circular references. https://community.qlik.com/t5/QlikView/How-to-avoid-synthetic-table-creation-and-circular-references/m-p/417732#M559162 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>you can make Link table to connect tables. In it you need to have Fact1 key, Fact 2 key, Dimension 1 Key and Dimension 2 Key. Also you need to delete Dimension 1 Key and Dimension 2 Key from Fact tables.</P><P></P><P>EDIT: You can see that <A _jive_internal="true" class="loading" href="https://community.qlik.com/blogs/qlikviewdesignblog/2013/05/17/concatenate-vs-link-table">http://community.qlik.com/blogs/qlikviewdesignblog/2013/05/17/concatenate-vs-link-table</A></P><P></P><P>Best,</P><P>Yani</P></BODY></HTML> Wed, 29 May 2013 13:51:57 GMT https://community.qlik.com/t5/QlikView/How-to-avoid-synthetic-table-creation-and-circular-references/m-p/417732#M559162 2013-05-29T13:51:57Z Re: How to avoid synthetic table creation and circular references. https://community.qlik.com/t5/QlikView/How-to-avoid-synthetic-table-creation-and-circular-references/m-p/417733#M559163 <HTML><HEAD></HEAD><BODY><P>As datulkim have said, join the tables. Then you can add a flag field to identify to which dimension each record belongs.</P></BODY></HTML> Wed, 29 May 2013 14:12:32 GMT https://community.qlik.com/t5/QlikView/How-to-avoid-synthetic-table-creation-and-circular-references/m-p/417733#M559163 2013-05-29T14:12:32Z Re: How to avoid synthetic table creation and circular references. https://community.qlik.com/t5/QlikView/How-to-avoid-synthetic-table-creation-and-circular-references/m-p/417734#M559164 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P></P><P>You can use the 'Qualify' in the tables!</P><P></P><P><IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P>Rebeca</P></BODY></HTML> Wed, 29 May 2013 14:28:52 GMT https://community.qlik.com/t5/QlikView/How-to-avoid-synthetic-table-creation-and-circular-references/m-p/417734#M559164 2013-05-29T14:28:52Z