Loops have been detected

[Anonymous]

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

[jerryyang756]

Please go through this link

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

[jonathandienst]

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