Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Rkota
Contributor III
Contributor III

Loop Message - help with understanding it

Hi there - I just created an application with a bunch of SQL which also uses a loop.  When I kick off a manual reload (close box unchecked), the following message is displayed

"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"

Not sure if this is pointing to a definite issue or is just a cautionary message?

I am generating about 11 data sets within the script - it's a fairly involved dashboard.

Thanks for any help/pointers in understanding and a possible fix.

Regards

1 Reply
marcus_sommer

Take a look here: Circular References and here: Synthetic Keys how to design a proper datamodel within qlik.

- Marcus