https://community.qlik.com/t5/QlikView/Issues-with-circular-references/m-p/1765314#M454232 <P>Hello everyone. I’m having some troubles to have 5 tables loaded without creating circular references and containing all connections needed. See below my data model:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="matheushsouza_0-1606756264058.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/45020iA50CD09622865154/image-size/medium?v=v2&amp;px=400" role="button" title="matheushsouza_0-1606756264058.png" alt="matheushsouza_0-1606756264058.png" /></span></P><P>&nbsp;</P><P>The issue started when I noticed JV table wasn’t connected to stores table and it was messing up with the report. When I forced them to be connected, it became circular.</P><P>Basically, the mapping table contains where a data in “LC” and “JV” tables should go. For example, an entry on account X on “LC” table should go to [OP Line] 1 as well as an entry on “JV” with account Y.</P><P>The “chave2” and “chave3” fields are concatenations created to avoid synthetic keys.</P><P>Do you guys have any suggestion to me to have this problem fixed and the report being able to be filtered by any field on the “stores” table?</P><P>I appreciate any support given.</P> Sat, 16 Nov 2024 17:45:45 GMT matheushsouza 2024-11-16T17:45:45Z https://community.qlik.com/t5/QlikView/Issues-with-circular-references/m-p/1765314#M454232 <P>Hello everyone. I’m having some troubles to have 5 tables loaded without creating circular references and containing all connections needed. See below my data model:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="matheushsouza_0-1606756264058.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/45020iA50CD09622865154/image-size/medium?v=v2&amp;px=400" role="button" title="matheushsouza_0-1606756264058.png" alt="matheushsouza_0-1606756264058.png" /></span></P><P>&nbsp;</P><P>The issue started when I noticed JV table wasn’t connected to stores table and it was messing up with the report. When I forced them to be connected, it became circular.</P><P>Basically, the mapping table contains where a data in “LC” and “JV” tables should go. For example, an entry on account X on “LC” table should go to [OP Line] 1 as well as an entry on “JV” with account Y.</P><P>The “chave2” and “chave3” fields are concatenations created to avoid synthetic keys.</P><P>Do you guys have any suggestion to me to have this problem fixed and the report being able to be filtered by any field on the “stores” table?</P><P>I appreciate any support given.</P> Sat, 16 Nov 2024 17:45:45 GMT https://community.qlik.com/t5/QlikView/Issues-with-circular-references/m-p/1765314#M454232 matheushsouza 2024-11-16T17:45:45Z https://community.qlik.com/t5/QlikView/Issues-with-circular-references/m-p/1765328#M454234 <P>You'll need to create what is called a "link table" in your data model.&nbsp; This article should be a good start in understanding what that is and how to implement it:<BR /><A href="https://community.qlik.com/t5/Qlik-Design-Blog/Concatenate-vs-Link-Table/ba-p/1467569" target="_blank">https://community.qlik.com/t5/Qlik-Design-Blog/Concatenate-vs-Link-Table/ba-p/1467569</A></P><P>Other searches for the term "link table" should get you more information as well.</P> Mon, 30 Nov 2020 18:56:04 GMT https://community.qlik.com/t5/QlikView/Issues-with-circular-references/m-p/1765328#M454234 Nicole-Smith 2020-11-30T18:56:04Z