topic Error Loop in QlikView

Error Loop

Fri, 11 Mar 2011 16:28:56 GMT

I have the following error occur when I run my script telling me that I have a loop error. I don't know what this means for me to do in my data structure and I was hoping somebody could help me.

Error Loop

Fri, 11 Mar 2011 16:56:54 GMT

happens when the tables are associated so that no more than a path of associationsbetween two fields

looks the part of Circular References ("Loops"), in manual

Error Loop

Fri, 11 Mar 2011 17:56:59 GMT

Hello if you click on the CTRL+T you will open the Table Viewer window, there you will see a dotted line for the loop where you see the error message. Just check the fields the line is linked to and rename anyone of the fields to anything else and then reload to get rid of this issue. QV automatically detects the tables and columns with the same name and tries to make an association, however we need to clear some by dropping them.

Eg: you might have a customer ID and Customer Name in Customer table and Customer ID, Customer name in sales Table, then you have to change the Customer in sales to something like Sales Customer so that it links with the Customer ID. Hope this helps.

ANDY