Loop Message - help with understanding it

Rkota — Tue, 07 Feb 2017 23:26:22 GMT

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

Re: Loop Message - help with understanding it

marcus_sommer — Wed, 08 Feb 2017 08:07:00 GMT

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

- Marcus

topic Loop Message - help with understanding it in QlikView

Loop Message - help with understanding it

Re: Loop Message - help with understanding it