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

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
jagan
Luminary Alumni
Luminary Alumni

Hi,

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

Regards,

Jagan.

View solution in original post

11 Replies
Oleg_Troyansky
Partner Ambassador/MVP
Partner Ambassador/MVP

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
Specialist II
Specialist II

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
Author

Hi Satish,

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

Not applicable
Author

Hi Satish,

Please find attached sample QVW for your refrence.

Regards,

Sunni

swuehl
MVP
MVP

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).

swuehl
MVP
MVP

Not applicable
Author

Swuehl,

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

Regards,

sunni

jagan
Luminary Alumni
Luminary Alumni

Hi,

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

Regards,

Jagan.

Not applicable
Author

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