QlikSense Data Model Circular Reference

[#1]

Hi,

I have a circular reference within my data model that I'm having trouble resolving.

Based on forums I've researched I've created a link table but this hasn't resolved my issue.

I've attached my model as a reference, any assistance is appreciated.

thanks

James

[r_wroblewski]

ifHi James

I marked your circular reference for better understanding.

I hope this will make it more easier to solve the issues.

The problem is that vContracts, vSite, vVehicles and ContractLink table create a circular reference.

E.g. if you can drop vehicleid from ContractLink table it would be solved, also just rename the field from "vehicleid" to "vehicleid_ref" will solve it. I don't know your requirements so let me know if this already helps you.

Regards

Ronny

[#3]

thanks Ronnie

[brunobertels]

Hi

Have a look to this doc it may help you fixe your issue :

Circular Reference

Bruno

[#5]

Better break the link between the tables Contract_link table with any of the adjacent table