topic Re: Avoiding Circular Joins in QlikView https://community.qlik.com/t5/QlikView/Avoiding-Circular-Joins/m-p/604577#M1234063 <HTML><HEAD></HEAD><BODY><P>Yes.But if you have more than one common column Qlikview&nbsp; will generate synthetic tables.</P><P></P><P>this is fine until unless you have any issue interns of performance or understanding of data model.</P><P></P><P>Because of synthetic keys you never get wrong data.</P></BODY></HTML> Thu, 20 Mar 2014 20:48:19 GMT chiru_thota 2014-03-20T20:48:19Z Avoiding Circular Joins https://community.qlik.com/t5/QlikView/Avoiding-Circular-Joins/m-p/604575#M1234059 <HTML><HEAD></HEAD><BODY><P>If multiple columns from different tables are having the same name, does Qlikview automatically join them? If yes, how does it take care of circular joins etc. ?</P></BODY></HTML> Mon, 26 Jan 2026 16:26:21 GMT https://community.qlik.com/t5/QlikView/Avoiding-Circular-Joins/m-p/604575#M1234059 2026-01-26T16:26:21Z Re: Avoiding Circular Joins https://community.qlik.com/t5/QlikView/Avoiding-Circular-Joins/m-p/604576#M1234061 <HTML><HEAD></HEAD><BODY><P>This is true. Qlikview links tables on similar field names. If there is a circular loop the largest table will be loosely coupled. This is not recommended.</P></BODY></HTML> Thu, 20 Mar 2014 20:45:49 GMT https://community.qlik.com/t5/QlikView/Avoiding-Circular-Joins/m-p/604576#M1234061 cgdonders 2014-03-20T20:45:49Z Re: Avoiding Circular Joins https://community.qlik.com/t5/QlikView/Avoiding-Circular-Joins/m-p/604577#M1234063 <HTML><HEAD></HEAD><BODY><P>Yes.But if you have more than one common column Qlikview&nbsp; will generate synthetic tables.</P><P></P><P>this is fine until unless you have any issue interns of performance or understanding of data model.</P><P></P><P>Because of synthetic keys you never get wrong data.</P></BODY></HTML> Thu, 20 Mar 2014 20:48:19 GMT https://community.qlik.com/t5/QlikView/Avoiding-Circular-Joins/m-p/604577#M1234063 chiru_thota 2014-03-20T20:48:19Z Re: Avoiding Circular Joins https://community.qlik.com/t5/QlikView/Avoiding-Circular-Joins/m-p/604578#M1234065 <HTML><HEAD></HEAD><BODY><P>use below url in the attached txt file to understand circular reference and how it is different from synthetic keys.</P><P></P><P></P><P>Circular reference will give wrong data if data is coming from loosely coupled tables.</P><P></P><P>also have look at below ppt.it is really helpful.</P><P><A href="https://community.qlik.com/docs/DOC-5830">Data Modeling issues and solutions</A></P></BODY></HTML> Thu, 20 Mar 2014 20:50:52 GMT https://community.qlik.com/t5/QlikView/Avoiding-Circular-Joins/m-p/604578#M1234065 chiru_thota 2014-03-20T20:50:52Z Re: Avoiding Circular Joins https://community.qlik.com/t5/QlikView/Avoiding-Circular-Joins/m-p/604579#M1234066 <HTML><HEAD></HEAD><BODY><P><A href="https://community.qlik.com/thread/45424">How circular reference can be avoided?</A></P><P><A href="https://community.qlik.com/thread/28959">What is Circular reference? How to avoid them?</A></P><P><A _jive_internal="true" href="https://community.qlik.com/blogs/qlikviewdesignblog/2013/06/25/circular-references" title="http://community.qlik.com/blogs/qlikviewdesignblog/2013/06/25/circular-references">http://community.qlik.com/blogs/qlikviewdesignblog/2013/06/25/circular-references</A></P></BODY></HTML> Thu, 20 Mar 2014 20:51:01 GMT https://community.qlik.com/t5/QlikView/Avoiding-Circular-Joins/m-p/604579#M1234066 MK_QSL 2014-03-20T20:51:01Z Re: Avoiding Circular Joins https://community.qlik.com/t5/QlikView/Avoiding-Circular-Joins/m-p/604580#M1234068 <HTML><HEAD></HEAD><BODY><P>Thank you for your prompt responses.</P></BODY></HTML> Wed, 09 Apr 2014 17:51:59 GMT https://community.qlik.com/t5/QlikView/Avoiding-Circular-Joins/m-p/604580#M1234068 2014-04-09T17:51:59Z