Loop in database structure

[#1]

Hi All

I have three tables like this:

When I reload the scripts, this message appears:

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.

So my question is, how can I avoid getting this error.

Thanks in advance.

Regards,

Ashkan

[qlikmsg4u]

Read this blog post by hic

Circular References

and this too

Re: Breaking Circular loop

[hic · Accepted solution]

I would put Sales Data and Target in the same table: Concatenate the target data with the actual data.

Then I would use a generic key for the calendar, i.e. a key that can mean both a month and a date. See more on Fact Table with Mixed Granularity

HIC

[#4]

Hi Henric

Thank you very much.