Getting Waring/error "One or more loops have been detected in your database structure"

[#1]

Hi Guys,

Getting below warning Error when reloading data into QVW file.

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

What could be the reason and how to resolve it?

I think this is due to same field name in 2 dimension tables and these dimension tables joining to fact table.

[#2 · Accepted solution]

Hi,

You are having common fields in more than 2 tables which is making a circular loop. Try to concatenate the two dimension tables in order to remove the loop.

HTH.

-Shruti

[#3]

Hi,

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

Circular loop :

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

Try to rename the fields and check

Hope it helps,

Regards,

Divya

[sudeepkm]

A good explanation on this can be found in the QlikView Reference Manual

Chapter 14 - Logic and Selections > 14.13 Circular References