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