topic Loop in database structure in QlikView

Loop in database structure

Wed, 16 Sep 2015 08:55:35 GMT

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

Re: Loop in database structure

qlikmsg4u — Wed, 16 Sep 2015 08:57:12 GMT

Read this blog post by hic

Circular References

and this too

Re: Breaking Circular loop

Re: Loop in database structure

hic — Wed, 16 Sep 2015 09:09:30 GMT

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

Re: Loop in database structure

Sun, 20 Sep 2015 11:12:57 GMT

Hi Henric

Thank you very much.