Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
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
A good explanation on this can be found in the QlikView Reference Manual
Chapter 14 - Logic and Selections > 14.13 Circular References