Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

How to use a calendar for more than one table?

Hello guys!

How do I solve this problem?
Please kindly help me.

I need the master calendar to interact with the table data (FAT) and with the table (INS). Both tables have dd / mm / yyyy date with the name 'competence'.

If I keep the same name in both tables I fall into the synthetic key problem and if I put different names, then the circular reference error occurs.

Circular reference: One or more loops have been detected in your database structure. Loops may cause ambiguous results and should therefore be avoided. Loop (s) will automatically be cut by setting one or more tables as loosely coupled. Use Loosen Table script statement to explicitly declare loosely coupled tables .: return.

Screenshot_1.png

Please help me!

Thanks for the attention and big hug.

🙂

Tags (2)
Labels (4)
1 Solution

Accepted Solutions
Highlighted
MVP
MVP

Re: How to use a calendar for more than one table?

A composite key will not resolve the circular reference. This data model needs some rework. You could concatenate the fact tables (it does not matter if they don't have many common fields), or (more likely in this case) link the tables through a link table.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

2 Replies
Highlighted

Re: How to use a calendar for more than one table?

Create the composite key which generate the syn key to map into calendar table. Check if that helps link-table

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
MVP
MVP

Re: How to use a calendar for more than one table?

A composite key will not resolve the circular reference. This data model needs some rework. You could concatenate the fact tables (it does not matter if they don't have many common fields), or (more likely in this case) link the tables through a link table.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post