What is the difference between loosely coupled circular reference

[#1]

Hi All,

What is the difference between loosely coupled circular reference. Can some one please explain!

[fernandotoledo]

They are different things that many times appears together...

Circular Reference is a "Circular Linking Chain" between your tables. This must not happen in QlikView data model because it would generate an infinite loop into QlikView's associative logic.

Loosely coupled tables are tables that have a link between them but the selection in one table doesn´t filter any data on the other, like they were disconnected. You can create Loosely coupled tables under Document Properties>Tables menu.

Loosely coupled tables apears automatically when QlikView finds a circular reference. It must break the link between some tables to resolve the data structure but keeps the tables linked (loosely) so you can study the structure an fix it.

[#3]

Hi Fernando,

Thanks for your reply! But still I am not clear by your points. What I want to know is whether loosely coupled keys are formed due to the circular reference or both are different. Hope some one can explain me!

What I am able to see from the below post is that loosely coupled key are formed due to the circular reference. Is it true? Please explain!

http://michaelellerbeck.com/2008/08/22/qlikview-circular-references/

[syed_muzammil]

Hi Rishab,

It that is true that circular references always cause QlikView to form a loosely coupled table (i think thats wat u mean ,not keys) . But all loosely coupled tables are not formed only because of circular references. We can create our own loosely coupled tables by placing LOOSEN before Load .

[#5]

Hi Syed,

Thanks for your reply. If we have not created the loosely coupled table then that means that qlikview has automatically created the loosely coupled tables. Am I right?