topic Re: How to remove Loops may cause ambiguous results ....? in QlikView https://community.qlik.com/t5/QlikView/How-to-remove-Loops-may-cause-ambiguous-results/m-p/841827#M295872 <HTML><HEAD></HEAD><BODY><P>It means that a circular loop is creating in your datamodel.</P><P></P><P>Identify which linking is not required, break the non-required link by aliasing them</P><P></P><P>This way your loops will get removed</P></BODY></HTML> Tue, 28 Apr 2015 14:41:13 GMT ankitaag 2015-04-28T14:41:13Z How to remove Loops may cause ambiguous results ....? https://community.qlik.com/t5/QlikView/How-to-remove-Loops-may-cause-ambiguous-results/m-p/841826#M295871 <HTML><HEAD></HEAD><BODY><P>Hi&nbsp; Forums,</P><P></P><P>Can you please advice how to remove the following error. FYI, It is get generated after re-Load of the script. <STRONG>Note: Already there is Link Table as LinkTab. But I am creating one more Link Table as LinkTab2.</STRONG></P><P></P><P>"One or more loops have been detected in your database structure. Loops may cause ambiguous results and should therefore be avoided. QlikView will cut the loop(s) by setting one or more tables as loosely coupled. Settings for loosely coupled tables can be modified after script execution in the tables page of the document properties dialog."</P><P></P><P>It will be highly appreciable. If I get solution quickly.</P><P></P><P>Thanks</P><P>SD</P></BODY></HTML> Tue, 28 Apr 2015 14:01:23 GMT https://community.qlik.com/t5/QlikView/How-to-remove-Loops-may-cause-ambiguous-results/m-p/841826#M295871 2015-04-28T14:01:23Z Re: How to remove Loops may cause ambiguous results ....? https://community.qlik.com/t5/QlikView/How-to-remove-Loops-may-cause-ambiguous-results/m-p/841827#M295872 <HTML><HEAD></HEAD><BODY><P>It means that a circular loop is creating in your datamodel.</P><P></P><P>Identify which linking is not required, break the non-required link by aliasing them</P><P></P><P>This way your loops will get removed</P></BODY></HTML> Tue, 28 Apr 2015 14:41:13 GMT https://community.qlik.com/t5/QlikView/How-to-remove-Loops-may-cause-ambiguous-results/m-p/841827#M295872 ankitaag 2015-04-28T14:41:13Z Re: How to remove Loops may cause ambiguous results ....? https://community.qlik.com/t5/QlikView/How-to-remove-Loops-may-cause-ambiguous-results/m-p/841828#M295873 <HTML><HEAD></HEAD><BODY><P>this post from HIC contains information regarding circular references </P><P></P><P><A href="https://community.qlik.com/qlik-blogpost/3178">Circular References</A></P></BODY></HTML> Tue, 28 Apr 2015 14:47:24 GMT https://community.qlik.com/t5/QlikView/How-to-remove-Loops-may-cause-ambiguous-results/m-p/841828#M295873 ramoncova06 2015-04-28T14:47:24Z Re: How to remove Loops may cause ambiguous results ....? https://community.qlik.com/t5/QlikView/How-to-remove-Loops-may-cause-ambiguous-results/m-p/841829#M295874 <HTML><HEAD></HEAD><BODY><P>review the names of the columns of your table try to have a star or snow flake schema</P></BODY></HTML> Tue, 28 Apr 2015 14:48:47 GMT https://community.qlik.com/t5/QlikView/How-to-remove-Loops-may-cause-ambiguous-results/m-p/841829#M295874 ali_hijazi 2015-04-28T14:48:47Z