Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi,
Break the relationship between Agency and Individual or Employee and Agency.
Regards,
Jagan.
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
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
Hi Satish,
I am not able to see attaching option(Advance editor).Can you please guide me how to attaching the qvw.
Hi Satish,
Please find attached sample QVW for your refrence.
Regards,
Sunni
You probably already know this blog post:
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,
Thank you for the information ,finally i have attached sample QVW .
Regards,
sunni
Hi,
Break the relationship between Agency and Individual or Employee and Agency.
Regards,
Jagan.
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