Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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.

1 Solution

Accepted Solutions
Not applicable
Author

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

View solution in original post

3 Replies
Not applicable
Author

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

View solution in original post

Not applicable
Author

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
Specialist III
Specialist III

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

Chapter 14 - Logic and Selections > 14.13 Circular References