topic Re: Alert Loop Warning in QlikView

Alert Loop Warning

gdilullo — Mon, 03 Jun 2013 09:24:15 GMT

Hi, I've got a problem with an "Alert Loop Warning" in my Qlikview project.

The content of the message is something like this:

"One or more circular references have been discovered in the structure of your database. They can cause ambiguous results and therefore should be avoided. QlikView will remove those circular references by setting one or more tables as loosely (by others). This setting can be changed after running the script in the property page of the document"

My intention isn't solve the loop, but HIDE this Message Alert.

Can anyone help me?

Thanks

Beppe

Re: Alert Loop Warning

jonathandienst — Mon, 03 Jun 2013 09:30:32 GMT

Circular refrences in the project usually indicate a data model problem. Associative logic cannot resolve the circular loop so Qlikview breaks one of the links (arbitrary choice). So QV has altered the data model.

If this table structure is what you want you should explicitly loosen the correct reference, but this would only be useful for rather exceptional circumstances.

So, no, I don't think that you can suppress this message. Why would you want to suppress such a warning?

Hope this helps

Jonathan

Re: Alert Loop Warning

gdilullo — Mon, 03 Jun 2013 10:17:49 GMT

Tnks Jonathan for your replay.

Since I haven't the ability to change data modeling in DB, I wanted to hide this message. Another possibility could be masking the problem by taking advantage of the QV' associative logic, but I'm not sure I can do. Have you got any ideas?

Beppe

Re: Alert Loop Warning

gdilullo — Tue, 04 Jun 2013 09:09:48 GMT

Problem solved. Thanks anyway Jonathan

Beppe