topic Re: Loops when loading a file. in QlikView

Loops when loading a file.

Wed, 31 Oct 2012 06:39:49 GMT

Hi can someone please help me to resolve the error below? I am getting it when reloading the 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."

Kind regards

Edzi

Re: Loops when loading a file.

Anonymous — Wed, 31 Oct 2012 06:45:50 GMT

ur case d situation may

table A links to table B links to table A

to solve plz rename the feilds which are common... n den proceed to link only those u want....wit common name....

regards,

vaibhav

Re: Loops when loading a file.

SunilChauhan — Wed, 31 Oct 2012 07:01:13 GMT

better to use

for each table

qualify * ;

unqualify primarykeyfield;

or else you can break a link in database which of list use.

hope this helps

Re: Loops when loading a file.

Wed, 31 Oct 2012 09:23:00 GMT

The fields does not have common names, but it seems like the problem is the common values in the fields that I am trying to connect with, I am trying to connect too excel files to a table in the sql database,

Standard Time per Rule is connected using Rule to the SQL table and

Benchmarks per Area is connected using PROCESSING AREA to the SQL table.

Any Idea how to resolve this?

Thanks

Edzi

The information in this email is confidential and may be legally privileged. It is intended solely for the addressee. Access to this email by anyone else is unauthorised. If you are not the intended recipient any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful

Re: Loops when loading a file.

Wed, 31 Oct 2012 09:26:00 GMT

Standard Time per Rule is connected using Rule to the SQL table and

Benchmarks per Area is connected using PROCESSING AREA to the SQL table.

Any Idea how to resolve this?

Thanks

Edzi

Re: Loops when loading a file.

Anonymous — Wed, 31 Oct 2012 10:41:53 GMT

hi as per ur given excels i tried loading .....bt itz fine....der isnt any problem in loading (Witout any loops)

wen u r selecting data from tab table file of qlikview make sure y select Embedded labels in label tab....

regards,

Vaibhav

Re: Loops when loading a file.

Wed, 31 Oct 2012 11:16:25 GMT

There is an extra table, an SQL table that I have to connect the two excel files with, that’s where I got the problem.

Thanks

Edzi