Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Live chat with experts, bring your API Integration questions. June 15th, 10 AM ET. REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
matheushsouza
Contributor
Contributor

Issues with circular references

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:

matheushsouza_0-1606756264058.png

 

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.

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.

The “chave2” and “chave3” fields are concatenations created to avoid synthetic keys.

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?

I appreciate any support given.

1 Reply
Nicole-Smith

You'll need to create what is called a "link table" in your data model.  This article should be a good start in understanding what that is and how to implement it:
https://community.qlik.com/t5/Qlik-Design-Blog/Concatenate-vs-Link-Table/ba-p/1467569

Other searches for the term "link table" should get you more information as well.