topic What should be the data model for circular reference table in QlikView https://community.qlik.com/t5/QlikView/What-should-be-the-data-model-for-circular-reference-table/m-p/356964#M132487 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>&nbsp; I have 3 tables... I am getting circular reference message so I changed the column names ( I could use QUALIFY as well).</P><P>But now I am not able to create the graphs as I wanted. So what should be my datamodel design where in I should get the appropriate results</P><P>and should not get any results if the data selected is irrelevant.</P><P></P><P>I have attached the sample xls and qvw file.</P><P></P><P></P><P>Thanks</P><P>Lax</P></BODY></HTML> Wed, 18 Apr 2012 11:07:14 GMT 2012-04-18T11:07:14Z What should be the data model for circular reference table https://community.qlik.com/t5/QlikView/What-should-be-the-data-model-for-circular-reference-table/m-p/356964#M132487 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>&nbsp; I have 3 tables... I am getting circular reference message so I changed the column names ( I could use QUALIFY as well).</P><P>But now I am not able to create the graphs as I wanted. So what should be my datamodel design where in I should get the appropriate results</P><P>and should not get any results if the data selected is irrelevant.</P><P></P><P>I have attached the sample xls and qvw file.</P><P></P><P></P><P>Thanks</P><P>Lax</P></BODY></HTML> Wed, 18 Apr 2012 11:07:14 GMT https://community.qlik.com/t5/QlikView/What-should-be-the-data-model-for-circular-reference-table/m-p/356964#M132487 2012-04-18T11:07:14Z What should be the data model for circular reference table https://community.qlik.com/t5/QlikView/What-should-be-the-data-model-for-circular-reference-table/m-p/356965#M132488 <HTML><HEAD></HEAD><BODY><P>Hi Laxmikant,</P><P></P><P>Dont alias the field names and just concatenate the three tables. You will not get any issues in the front end.</P><P></P><P>Regards,</P><P>Kiran Rokkam.</P></BODY></HTML> Wed, 18 Apr 2012 11:16:45 GMT https://community.qlik.com/t5/QlikView/What-should-be-the-data-model-for-circular-reference-table/m-p/356965#M132488 2012-04-18T11:16:45Z What should be the data model for circular reference table https://community.qlik.com/t5/QlikView/What-should-be-the-data-model-for-circular-reference-table/m-p/356966#M132489 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Load a Mastertable - the one with both Branch and PolNo first. Then Left Join or Concatenate LOAD the other two tables...</P><P></P><P></P><P>Best regards</P><P>Torbjörn Ungvall (@Ungvall)</P><P>Senior Business Discovery Manager @ Advectas AB</P></BODY></HTML> Wed, 18 Apr 2012 11:20:54 GMT https://community.qlik.com/t5/QlikView/What-should-be-the-data-model-for-circular-reference-table/m-p/356966#M132489 2012-04-18T11:20:54Z Re: What should be the data model for circular reference table https://community.qlik.com/t5/QlikView/What-should-be-the-data-model-for-circular-reference-table/m-p/356967#M132490 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>&nbsp; I concatenated the tables, now I get data for one graph. But for another I don't i.e the PAMOUNT is shown but no branch is shown for it. Similarly if I select PHGender or REGION I don't see the PAMOUNT. I should be able to see the PAMOUNT for this selection.</P><P></P><P>I am attaching the modified docs.</P><P></P><P>Thanks,</P><P>Lax</P></BODY></HTML> Wed, 18 Apr 2012 12:38:04 GMT https://community.qlik.com/t5/QlikView/What-should-be-the-data-model-for-circular-reference-table/m-p/356967#M132490 2012-04-18T12:38:04Z What should be the data model for circular reference table https://community.qlik.com/t5/QlikView/What-should-be-the-data-model-for-circular-reference-table/m-p/356968#M132491 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Same result if you use LEFT Join (Mastertable) instead?</P><P></P><P></P><P>Best regards</P><P>Torbjörn Ungavll (@Ungvall)</P><P>Senior Business Discovery Manager @ Advectas AB</P></BODY></HTML> Wed, 18 Apr 2012 12:54:33 GMT https://community.qlik.com/t5/QlikView/What-should-be-the-data-model-for-circular-reference-table/m-p/356968#M132491 2012-04-18T12:54:33Z Re: What should be the data model for circular reference table https://community.qlik.com/t5/QlikView/What-should-be-the-data-model-for-circular-reference-table/m-p/356969#M132492 <HTML><HEAD></HEAD><BODY><P>Updated the file. Does this work?</P><P></P><P>Regards,</P><P>Kiran.</P></BODY></HTML> Thu, 19 Apr 2012 04:52:23 GMT https://community.qlik.com/t5/QlikView/What-should-be-the-data-model-for-circular-reference-table/m-p/356969#M132492 2012-04-19T04:52:23Z Re: What should be the data model for circular reference table https://community.qlik.com/t5/QlikView/What-should-be-the-data-model-for-circular-reference-table/m-p/356970#M132493 <HTML><HEAD></HEAD><BODY><P> Hi, Thanks for the multiple solution, one with explicit key&nbsp; and other without it...both of them work.</P><P></P><P></P><P>Regards,</P><P>Lax</P></BODY></HTML> Thu, 19 Apr 2012 06:56:35 GMT https://community.qlik.com/t5/QlikView/What-should-be-the-data-model-for-circular-reference-table/m-p/356970#M132493 2012-04-19T06:56:35Z