topic circular references - error in script! in QlikView https://community.qlik.com/t5/QlikView/circular-references-error-in-script/m-p/148575#M26852 <HTML><HEAD></HEAD><BODY><P>In simple terms, you alias all your foreign keys to prevent the associations then you create a table, using a combination of Resident, Join and Concatenate, containing all the Primary keys that are associated to each other. You end up with a star schema.</P><P>I can't give you specific instructions on your document because I don't have a copy of it - that might be beyond the scope of a forum like this anyway!</P><P></P><P>Regards,</P><P></P><P>Stephen</P><P></P></BODY></HTML> Mon, 06 Jul 2009 18:43:02 GMT stephencredmond 2009-07-06T18:43:02Z circular references - error in script! https://community.qlik.com/t5/QlikView/circular-references-error-in-script/m-p/148571#M26848 <HTML><HEAD></HEAD><BODY><P>Hi everyone,</P><P>I am getting circular ref/loops in my script, I'm looking to join 2 tables which I have attached, so that I can have a unit, dept, team hierarchy. However, most tabs in my script have this and trying the new join creates these loops.</P><P>If anyone could help it would be much appreciated as it is quite urgent.</P><P>Regards</P></BODY></HTML> Mon, 06 Jul 2009 17:35:39 GMT https://community.qlik.com/t5/QlikView/circular-references-error-in-script/m-p/148571#M26848 2009-07-06T17:35:39Z AW:circular references - error in script! https://community.qlik.com/t5/QlikView/circular-references-error-in-script/m-p/148572#M26849 <HTML><HEAD></HEAD><BODY><P>Why do you CONCATENATE three different tables? <span class="lia-unicode-emoji" title=":winking_face:">😉</span></P></BODY></HTML> Mon, 06 Jul 2009 17:52:01 GMT https://community.qlik.com/t5/QlikView/circular-references-error-in-script/m-p/148572#M26849 2009-07-06T17:52:01Z circular references - error in script! https://community.qlik.com/t5/QlikView/circular-references-error-in-script/m-p/148573#M26850 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>That document is not very helpful to me - it is a snippet of a script with no context/data to relate to. Sorry.</P><P>In general, a circular reference is created when a field in Table A associates to a field in Table B, a different field associates from Table B to Table C and another field associates from Table C to Table A (there may be many more tables involved).</P><P>The simple way to solve this problem is to look at your associations and decide if one of them is either completely incorrect, or just not relevant for your document.</P><P>If you find that you need all of them then you need to look at creating a key table to associate all the data.</P><P></P><P>Regards,</P><P></P><P>Stephen</P><P></P></BODY></HTML> Mon, 06 Jul 2009 18:00:16 GMT https://community.qlik.com/t5/QlikView/circular-references-error-in-script/m-p/148573#M26850 stephencredmond 2009-07-06T18:00:16Z circular references - error in script! https://community.qlik.com/t5/QlikView/circular-references-error-in-script/m-p/148574#M26851 <HTML><HEAD></HEAD><BODY><P>I believe that all the associations are necessary. Will a key table remove the circular references? What way would I go about creating such a table? I appreciate your help.</P></BODY></HTML> Mon, 06 Jul 2009 18:26:33 GMT https://community.qlik.com/t5/QlikView/circular-references-error-in-script/m-p/148574#M26851 2009-07-06T18:26:33Z circular references - error in script! https://community.qlik.com/t5/QlikView/circular-references-error-in-script/m-p/148575#M26852 <HTML><HEAD></HEAD><BODY><P>In simple terms, you alias all your foreign keys to prevent the associations then you create a table, using a combination of Resident, Join and Concatenate, containing all the Primary keys that are associated to each other. You end up with a star schema.</P><P>I can't give you specific instructions on your document because I don't have a copy of it - that might be beyond the scope of a forum like this anyway!</P><P></P><P>Regards,</P><P></P><P>Stephen</P><P></P></BODY></HTML> Mon, 06 Jul 2009 18:43:02 GMT https://community.qlik.com/t5/QlikView/circular-references-error-in-script/m-p/148575#M26852 stephencredmond 2009-07-06T18:43:02Z circular references - error in script! https://community.qlik.com/t5/QlikView/circular-references-error-in-script/m-p/148576#M26853 <HTML><HEAD></HEAD><BODY><P>I have posted a Wiki entry on strategy for creating Key tables:</P><P><A href="http://community.qlik.com/wikis/qlikview-wiki/strategy-for-creating-key-tables.aspx">http://community.qlik.com/wikis/qlikview-wiki/strategy-for-creating-key-tables.aspx</A></P><P></P><P></P></BODY></HTML> Mon, 06 Jul 2009 18:55:49 GMT https://community.qlik.com/t5/QlikView/circular-references-error-in-script/m-p/148576#M26853 stephencredmond 2009-07-06T18:55:49Z circular references - error in script! https://community.qlik.com/t5/QlikView/circular-references-error-in-script/m-p/148577#M26854 <HTML><HEAD></HEAD><BODY><P>Thanks Stephen,</P><P>I'll give that a try!</P></BODY></HTML> Mon, 06 Jul 2009 19:59:42 GMT https://community.qlik.com/t5/QlikView/circular-references-error-in-script/m-p/148577#M26854 2009-07-06T19:59:42Z