topic Re: Query on circular reference in QlikView https://community.qlik.com/t5/QlikView/Query-on-circular-reference/m-p/1352733#M834698 <HTML><HEAD></HEAD><BODY><P><IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Mon, 29 May 2017 10:59:01 GMT kamal_sanguri 2017-05-29T10:59:01Z Query on circular reference https://community.qlik.com/t5/QlikView/Query-on-circular-reference/m-p/1352728#M834693 <HTML><HEAD></HEAD><BODY><P>I loaded some table which is contain 1 common field and there is no fact table.</P><P>in this data model we can Travers from one table to another by using many path then why circular reference is not formed here. </P><P></P><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/165059_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P><P></P><P>thank you.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Query-on-circular-reference/m-p/1352728#M834693 Anonymous 2020-11-25T16:16:04Z Re: Query on circular reference https://community.qlik.com/t5/QlikView/Query-on-circular-reference/m-p/1352729#M834694 <HTML><HEAD></HEAD><BODY><P>Hi Prachi,</P><P></P><P>Circular reference would not happen because of the special structure of tables (All tables are connected with key). Hence, Qlikview engine in this case would not require to go through any intermediate table. Although you may have same columns to query in different tables but path would remain same and that would be direct.</P><P></P><P>By just breaking this key in table 'P' and adding a column, Now there is a circular loop. Because, Now QV engine has different path to access same column.</P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/165064_Capture.PNG" style="height: 392px; width: 620px;" /></P></BODY></HTML> Mon, 29 May 2017 09:39:09 GMT https://community.qlik.com/t5/QlikView/Query-on-circular-reference/m-p/1352729#M834694 kamal_sanguri 2017-05-29T09:39:09Z Re: Query on circular reference https://community.qlik.com/t5/QlikView/Query-on-circular-reference/m-p/1352730#M834695 <HTML><HEAD></HEAD><BODY><P>that meas in my data model only path is there...</P><P></P><P>is right?</P></BODY></HTML> Mon, 29 May 2017 10:19:39 GMT https://community.qlik.com/t5/QlikView/Query-on-circular-reference/m-p/1352730#M834695 Anonymous 2017-05-29T10:19:39Z Re: Query on circular reference https://community.qlik.com/t5/QlikView/Query-on-circular-reference/m-p/1352731#M834696 <HTML><HEAD></HEAD><BODY><P>Yes, you have direct path between any table to any table.</P></BODY></HTML> Mon, 29 May 2017 10:23:58 GMT https://community.qlik.com/t5/QlikView/Query-on-circular-reference/m-p/1352731#M834696 kamal_sanguri 2017-05-29T10:23:58Z Re: Query on circular reference https://community.qlik.com/t5/QlikView/Query-on-circular-reference/m-p/1352732#M834697 <HTML><HEAD></HEAD><BODY><P>ok, thank you so much.</P></BODY></HTML> Mon, 29 May 2017 10:58:25 GMT https://community.qlik.com/t5/QlikView/Query-on-circular-reference/m-p/1352732#M834697 Anonymous 2017-05-29T10:58:25Z Re: Query on circular reference https://community.qlik.com/t5/QlikView/Query-on-circular-reference/m-p/1352733#M834698 <HTML><HEAD></HEAD><BODY><P><IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Mon, 29 May 2017 10:59:01 GMT https://community.qlik.com/t5/QlikView/Query-on-circular-reference/m-p/1352733#M834698 kamal_sanguri 2017-05-29T10:59:01Z