topic Re: Loops have been detected in App Development

Loops have been detected

Anonymous — Tue, 06 Mar 2018 05:52:02 GMT

Hi,

I got this error :

Error :

Circular reference:

One or more loops have been detected in your database structure. Loops may cause ambiguous results and should therefore be avoided. Loop(s) will automatically be cut by setting one or more tables as loosely coupled. Use Loosen Table script statement to explicitly declare loosely coupled tables.: return

Any Idea how I can fix it?

Thanks in advance.

Regards

Re: Loops have been detected

jerryyang756 — Tue, 06 Mar 2018 05:57:39 GMT

Please go through this link

https://help.qlik.com/en-US/sense/September2017/Subsystems/Hub/Content/LoadData/understand-circular-references.htm

Re: Loops have been detected

jonathandienst — Tue, 13 Mar 2018 09:02:37 GMT

SQL foreign keys have a direction (from the PKey to the FKey), so you can have more than one path from one field to another in the SQL foreign key structure.

By contrast, Qlik models are associative databases and an associative database has no concept of direction of an association. So multiple paths between two fields cause possible ambiguity and are therefore disallowed. Usually this problem arises when the data model design has not been properly developed.

These links apply to QV models, but the same principles apply to QS:

Get started with developing qlik datamodels

Advanced topics for creating a qlik datamodel