Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Loop in database structure

Hi All

I have three tables like this:

loop in database structure.jpgWhen 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

1 Solution

Accepted Solutions
Henric_Cronström

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

View solution in original post

3 Replies
qlikmsg4u
Specialist
Specialist

Read this blog post by hic

Circular References

and this too

Re: Breaking Circular loop

Henric_Cronström

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

View solution in original post

Not applicable
Author

Hi Henric

Thank you very much.