topic Re: Why circular reference doesn't exist? in QlikView

Why circular reference doesn't exist?

manishchandra_j — Tue, 15 Mar 2016 06:06:29 GMT

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.

Re: Why circular reference doesn't exist?

amayuresh — Tue, 15 Mar 2016 09:16:32 GMT

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

Re: Why circular reference doesn't exist?

Anonymous — Tue, 15 Mar 2016 09:21:19 GMT

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.

Customers: Orders: Calendar:
CustomerID --> CustomerID
Date OrderDate --> OrderDate AS Date

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

Re: Why circular reference doesn't exist?

Anonymous — Tue, 15 Mar 2016 09:25:05 GMT

The Fact Tables are linked together via your CompositeKeySeq field.

Is there a reason why you think they are not ?

Re: Why circular reference doesn't exist?

sfatoux72 — Tue, 15 Mar 2016 09:36:52 GMT

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)

Re: Why circular reference doesn't exist?

manishchandra_j — Tue, 15 Mar 2016 11:38:42 GMT

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