topic Loops detected in QlikView

Loops detected

Wed, 27 Nov 2013 11:00:45 GMT

Hi,

I am loading six excel tables all seems OK, but when the reload is completed the following message is displayed:

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.

Any idea what it is and how can I fix it.

Thanks in advance,

- A problem only becomes a problem when we choose to see it as a problem (vs. an opportunity) -

Re: Loops detected

Wed, 27 Nov 2013 11:04:48 GMT

Hi,

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

Circular loop is :

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

You can rename the fields causing this loop.

Hope this helps, if not, post your sample app here if possible.

Edit: After seeing your table structure, you can rename "Weeknbr" column from Calendar table and this loop will break.

(This is one of many options that can be done here)

Re: Loops detected

Wed, 27 Nov 2013 11:06:30 GMT

in your data model circular loops are made.

for avoid this

change the field name.

or join the table.

or concate tables

Re: Loops detected

Wed, 27 Nov 2013 11:10:35 GMT

in your model,

remove the link WeekNbr.

or you can join calender table either in SKG on the basis of Month

or join calender table in TEL_Row on the basis of WeekNbr.

Re: Loops detected

marcus_malinow — Wed, 27 Nov 2013 11:11:40 GMT

Hi Vitor,

this is a fairly common issue in data modelling in QlikView. Typically when resolving this you can concatenate tables together, or create a Link table.

Here are a few links which should help you to resolve this:

Circular References - http://community.qlik.com/blogs/qlikviewdesignblog/2013/06/25/circular-references

Concatenate vs Link Table - http://community.qlik.com/blogs/qlikviewdesignblog/2013/05/17/concatenate-vs-link-table

Data Modelling - http://community.qlik.com/docs/DOC-4744

Hope these are helpful!

Marcus

Re: Loops detected

Wed, 27 Nov 2013 12:00:42 GMT

Thanks Shyamal

Re: Loops detected

Wed, 27 Nov 2013 12:01:46 GMT

Thanks Vishwaranjan

Re: Loops detected

Wed, 27 Nov 2013 12:06:52 GMT

Thanks Marcus,

I am still evaluating the tool before I present it to Higher management, but I will have a better look into your suggestions.