Loops detected

[#1]

Hi,

I am loading six excel tables all seems OK, but when the reload is completed 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.

Any idea what it is and how can I fix it.

Thanks in advance,

- A problem only becomes a problem when we choose to see it as a problem (vs. an opportunity) -

[#2 · Accepted solution]

Hi,

This is because a circular loop is getting created in your tables.

Circular loop is : 

"A structure in the data model where the keys between at least three tables form a circle."

You can rename the fields causing this loop.

Hope this helps, if not, post your sample app here if possible.

Edit: After seeing your table structure, you can rename "Weeknbr" column from Calendar table and this loop will break.

(This is one of many options that can be done here)

[#3]

hi

in your data model circular loops are made.

for avoid this

change the field name.

or join the table.

or concate tables

[#4]

hi

in your model,

remove the link WeekNbr.

or you can join calender table either in SKG on the basis of Month

or join calender table in TEL_Row on the basis of WeekNbr.

[marcus_malinow]

Hi Vitor,

this is a fairly common issue in data modelling in QlikView. Typically when resolving this you can concatenate tables together, or create a Link table.

Here are a few links which should help you to resolve this:

Circular References - http://community.qlik.com/blogs/qlikviewdesignblog/2013/06/25/circular-references

Concatenate vs Link Table - http://community.qlik.com/blogs/qlikviewdesignblog/2013/05/17/concatenate-vs-link-table

Data Modelling - http://community.qlik.com/docs/DOC-4744

Hope these are helpful!

Marcus

[#6]

Thanks Shyamal

[#7]

Thanks Vishwaranjan

[#8]

Thanks Marcus,

I am still evaluating the tool before I present it to Higher management, but I will have a better look into your suggestions.