Why circular reference doesn't exist?

[manishchandra_j]

Hello Everyone,

I would like to understand below scenario. Where I was expecting that there would be multiple circular references among the fact tables(with blue heading). As they are linked with same field 'CompositeKeySeq'. This field is in all  fact tables and Link table but surprisingly Link table appear to be central table, which is good. but want to understand why, fact tables ae not getting linked with each other.

Thanks in advance.

[amayuresh]

A Circular reference (also called Circular loop) happens when one table is reachable by two or more ways.

Please check this below post http://community.qlik.com/blogs/qlikviewdesignblog/2013/06/25/circular-references

[Anonymous]

Hi Lokash,

A circular reference (also called loop) happens when one table is reachable by two or more ways. As in QlikView tables are linked when two or more fields are named alike, the likeliest reason is that there are more than two tables with the same field names that link to each other.

1. Customers:       Orders:          Calendar:
2. CustomerID -->   CustomerID   
3. Date             OrderDate -->     OrderDate AS Date 

Customers links to Orders that links to Calendar that in turn links to Customers.

[Anonymous]

The Fact Tables are linked together via your CompositeKeySeq field.

Is there a reason why you think they are not ?

[sfatoux72 · Accepted solution]

Hi,

To have a circular reference, you need to have at least three tables linked by different field liked below.

We see clearly the circular reference.

In your case, you have a lot of table but linked all together with only one field (it's perfect)

[manishchandra_j]

Thanks Everyone for your replies and making me understand why there is no circular reference.