topic Re: Loops warning!!! in QlikView https://community.qlik.com/t5/QlikView/Loops-warning/m-p/697453#M251906 <HTML><HEAD></HEAD><BODY><P>Hi Mafaz,</P><P></P><P>Can you please post the app.</P></BODY></HTML> Wed, 03 Sep 2014 11:36:40 GMT avinashelite 2014-09-03T11:36:40Z Loops warning!!! https://community.qlik.com/t5/QlikView/Loops-warning/m-p/697444#M251897 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Can any one emplane the warning popup below and please emplane how to avoid the warning..</P><P></P><P><IMG alt="error.jpg" class="jive-image" src="https://community.qlik.com/legacyfs/online/65803_error.jpg" style="max-width: 620px;" /></P></BODY></HTML> Wed, 03 Sep 2014 09:51:50 GMT https://community.qlik.com/t5/QlikView/Loops-warning/m-p/697444#M251897 2014-09-03T09:51:50Z Re: Loops warning!!! https://community.qlik.com/t5/QlikView/Loops-warning/m-p/697445#M251898 <HTML><HEAD></HEAD><BODY><P>if it is possible avoid loops doing join (Left or outer) between tables where loops appears. I can help ypou more if you attach the tables view.</P></BODY></HTML> Wed, 03 Sep 2014 09:54:10 GMT https://community.qlik.com/t5/QlikView/Loops-warning/m-p/697445#M251898 alexandros17 2014-09-03T09:54:10Z Re: Loops warning!!! https://community.qlik.com/t5/QlikView/Loops-warning/m-p/697446#M251899 <HTML><HEAD></HEAD><BODY><P>I knew from where the warning is popping up but the thing is I need <STRONG>BUY </STRONG>and <STRONG>STYLE_NAME </STRONG>as primary key I need both to be linked. please find the view below </P><P></P><P><IMG alt="table.jpg" class="jive-image" src="https://community.qlik.com/legacyfs/online/65810_table.jpg" style="width: 620px; height: 410px;" /></P></BODY></HTML> Wed, 03 Sep 2014 10:35:59 GMT https://community.qlik.com/t5/QlikView/Loops-warning/m-p/697446#M251899 2014-09-03T10:35:59Z Re: Loops warning!!! https://community.qlik.com/t5/QlikView/Loops-warning/m-p/697447#M251900 <HTML><HEAD></HEAD><BODY><P>See if these help:</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">circular-references</A></P><P><A href="https://community.qlik.com/thread/45424">How circular reference can be avoided?</A></P></BODY></HTML> Wed, 03 Sep 2014 10:44:08 GMT https://community.qlik.com/t5/QlikView/Loops-warning/m-p/697447#M251900 tresB 2014-09-03T10:44:08Z Re: Loops warning!!! https://community.qlik.com/t5/QlikView/Loops-warning/m-p/697448#M251901 <HTML><HEAD></HEAD><BODY><P>remove the sync1 table ids by renaming it to other names like styleid as style_id then loop will be remove.</P></BODY></HTML> Wed, 03 Sep 2014 10:48:54 GMT https://community.qlik.com/t5/QlikView/Loops-warning/m-p/697448#M251901 vinay_hg 2014-09-03T10:48:54Z Re: Loops warning!!! https://community.qlik.com/t5/QlikView/Loops-warning/m-p/697449#M251902 <HTML><HEAD></HEAD><BODY><P>how do I rename, it is a table created by qlikview</P></BODY></HTML> Wed, 03 Sep 2014 11:07:21 GMT https://community.qlik.com/t5/QlikView/Loops-warning/m-p/697449#M251902 2014-09-03T11:07:21Z Re: Loops warning!!! https://community.qlik.com/t5/QlikView/Loops-warning/m-p/697450#M251903 <HTML><HEAD></HEAD><BODY><P>Hi , In script you can rename the fields causing circular reference.</P><P>STYLE_ID as STYLE_ID1 or any suitable name</P></BODY></HTML> Wed, 03 Sep 2014 11:10:37 GMT https://community.qlik.com/t5/QlikView/Loops-warning/m-p/697450#M251903 vijay_iitkgp 2014-09-03T11:10:37Z Re: Loops warning!!! https://community.qlik.com/t5/QlikView/Loops-warning/m-p/697451#M251904 <HTML><HEAD></HEAD><BODY><P>yeah but I need all <STRONG>STYLE_ID</STRONG>s and <STRONG>BUY</STRONG>s to be linked </P></BODY></HTML> Wed, 03 Sep 2014 11:15:36 GMT https://community.qlik.com/t5/QlikView/Loops-warning/m-p/697451#M251904 2014-09-03T11:15:36Z Re: Loops warning!!! https://community.qlik.com/t5/QlikView/Loops-warning/m-p/697452#M251905 <HTML><HEAD></HEAD><BODY><P>Then Please create concatenated Key by Using STYLE_ID&amp;BUY&nbsp; to link and rename other fields.</P></BODY></HTML> Wed, 03 Sep 2014 11:17:26 GMT https://community.qlik.com/t5/QlikView/Loops-warning/m-p/697452#M251905 vijay_iitkgp 2014-09-03T11:17:26Z Re: Loops warning!!! https://community.qlik.com/t5/QlikView/Loops-warning/m-p/697453#M251906 <HTML><HEAD></HEAD><BODY><P>Hi Mafaz,</P><P></P><P>Can you please post the app.</P></BODY></HTML> Wed, 03 Sep 2014 11:36:40 GMT https://community.qlik.com/t5/QlikView/Loops-warning/m-p/697453#M251906 avinashelite 2014-09-03T11:36:40Z Re: Loops warning!!! https://community.qlik.com/t5/QlikView/Loops-warning/m-p/697454#M251907 <HTML><HEAD></HEAD><BODY><P>Hi!</P><P></P><P>You need to change your datamodel a little.</P><P></P><P>From that point on script:</P><P></P><P>tmp_STYLE_MASTER:</P><P>Load * Resident STYLE_MASTER;</P><P></P><P>Join (STYLE_MASTER)</P><P></P><P>Load * Resident Factory;</P><P></P><P>Join (STYLE_MASTER)</P><P></P><P>Load * Resident Buyer;</P><P></P><P>Join (STYLE_MASTER)</P><P></P><P>Load * Resident Locations;</P><P></P><P>Join (STYLE_D_MCT)</P><P></P><P>Load * Resident tmp_STYLE_MASTER;</P><P></P><P>Drop tables STYLE_MASTER, Factory, Buyer, Locations, tmp_STYLE_MASTER;</P><P></P><P>Last join is a bit of a question mark. That should simplify your datamodel and if that last join works you dont have any more circular references.</P><P></P><P>Br,</P><P>Miikka</P><P>Climber Finland</P></BODY></HTML> Wed, 03 Sep 2014 12:33:56 GMT https://community.qlik.com/t5/QlikView/Loops-warning/m-p/697454#M251907 miikkaqlick 2014-09-03T12:33:56Z