Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

QlikSense Data Model Circular Reference

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

4 Replies
r_wroblewski
Contributor III

Re: QlikSense Data Model Circular Reference

ifHi James

I marked your circular reference for better understanding.

dm.png

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

Not applicable

Re: QlikSense Data Model Circular Reference

thanks Ronnie

brunobertels
Valued Contributor

Re: QlikSense Data Model Circular Reference

Hi

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

Circular Reference

Bruno

Not applicable

Re: QlikSense Data Model Circular Reference

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