Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Circular loop

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.

Here is my internal table view: Does anyone know what my issue is?

export.png

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Try concatenating these 3 tables together :

     Consolidate...

     Resource L...

     Pivot ChartS

View solution in original post

8 Replies
Anonymous
Not applicable
Author

Try concatenating these 3 tables together :

     Consolidate...

     Resource L...

     Pivot ChartS

Not applicable
Author

I believe in your datamodel 3 synthetic keys are present.

1) first synthetic between table  reports by project and efforts by resource .

2) second syn key between  consolidate and resource table

3) third syn key between  pivot chart and resource tab;e

dashed lined represent loosly coupled table

Anonymous
Not applicable
Author

Hey,

there are sync tables are generated due to common columns.

If the dimension attributes are already present in your Fact table, you may rename the columns from dimension tables. Try to merge the Dimensions togeather one table where ever synthetic key happening in scripting side.

I think you can merge consolidated and resource table as all the columns seems to be same..to differenciate the data between these 2 tables after merge, you may have a static flag to identify the source data(like flag field will be  C for consolidated and R for resource table).

like wise you can play with other tablesbased on possibility.

Regards,

Chinna

Not applicable
Author

Hi,

I can see a lot of problem in your data model in terms of Synthetic Tables and Circular Reference getting formed.

Please remove them to correct your data model.

Hope the below links help !

Circular Reference :  http://floydmatt.com/2011/06/how-to-prevent-circular-reference-in-a-qlikview-data-model-quick-qlear-...

Synthetic Key : http://community.qlik.com/thread/79109

Not applicable
Author

you can try

1) concatenating  resource and consolidate table

2) concatenating  effort by resource and reports by projects

Not applicable
Author

Thank you I will try to do this now.

Not applicable
Author

Thank you for your response, i'll look into these.

hic
Former Employee
Former Employee

Read also Circular References.

HIC