Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

How to avoid Circular Reference

Hi All,

Please can anyone help me how to avoid circular references and i need to maintain relationship between the tables such as :Client --Individual--Agency--Objectinvlovement. Here is the attaching sample QVW.

PFA.png

1 Solution

Accepted Solutions
MVP
MVP

Re: How to avoid Circular Reference

Hi,

Break the relationship between Agency and Individual or Employee and Agency.

Regards,

Jagan.

11 Replies
MVP
MVP

Re: How to avoid Circular Reference

Hi Sunni,

I think your problem is a bit too specific and too complicated to be solved over a community question. In order to untangle your data, someone needs to understand all the associations in your data model and develop the data modelling solution for it.

If you'd like to understand how to do it by yourself, you need to learn QlikView Data Modelling principles. I'm sure there are many free white papers that you can dig up on this forum. In addition, I can recommend reading my new book QlikView Your Business, that describes all the principles and the techniques that are necessary to become a successful QlikView/Qlik Sense developer.

cheers,

Oleg Troyansky

satishkurra
Valued Contributor II

Re: How to avoid Circular Reference

If you have the data files and qvw, please share. It would be difficult to solve looking at screen shot for this as Oleg Troyansky mentioned

Not applicable

Re: How to avoid Circular Reference

Hi Satish,

I am not able to see attaching option(Advance editor).Can you please guide me how to attaching the qvw.

Not applicable

Re: How to avoid Circular Reference

Hi Satish,

Please find attached sample QVW for your refrence.

Regards,

Sunni

MVP
MVP

Re: How to avoid Circular Reference

You probably already know this blog post:

Circular References

As described therein, the key to resolve your issue is that you define the roles (maybe with the help of someone who knows the business you are modelling).

MVP
MVP

Re: How to avoid Circular Reference

Not applicable

Re: How to avoid Circular Reference

Swuehl,

Thank you for the information ,finally i have attached sample QVW .

Regards,

sunni

MVP
MVP

Re: How to avoid Circular Reference

Hi,

Break the relationship between Agency and Individual or Employee and Agency.

Regards,

Jagan.

Not applicable

Re: How to avoid Circular Reference

Hi Jagan ,


Thank you for getting back to me ,I need to maintain relation between the tables :individual to agency to employee and agency to objectinvolvement.can you please guide me is there any other solution to avoid circular ref .


Regards ,

Sunni

Community Browser