Qlik Community

Qlik Sense App Development

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

Highlighted
edugallowk
New 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
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
2 Replies

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)
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