one or more loops in db structure and dashed lines- not sure why...

[ellyodelly]

message received: 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

I am attaching a snap shot from table viewer and an export of my script.

I do not understand what the dashed lines with the arrowhead to my DashCtrl table are indicating.   and I am not sure where the loop is?

yep-  I am a newbie-  seeking some light on the subject.

thank you!

[Gysbert_Wassenaar · Accepted solution]

You have one loop. In DashCtrl you have two fields AR_Key and SalesOrderKey. These fields each exist in another table. So there are two routes to go from Customers to DashCtrl. That's the loop. Any connection to DashCtrl is shown with a dashed line because of this. What you need to decide is which 'route' you want to keep. You could also look at the other end of the loop. The Customer table links to Receivables and Sales_Order_Invoices. You could remove on of those links too to resolve the loop problem. But I think DashCtrl is probably the better option. Rename one of the two fields so one of the links is removed and the loop is resolved.

[ellyodelly]

Thanks!

[#4]

hmmm I don't really get it. I'm facing the exact same problem

How do  you identify which fields have been looped? How do you resolve it?

[djsampat]

The Dashes are the connections to loops. Either Qualify the columns or Concatenate the tables.