topic What is the difference between loosely coupled circular reference in QlikView

What is the difference between loosely coupled circular reference

Wed, 30 Jun 2010 12:43:38 GMT

Hi All,

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

What is the difference between loosely coupled circular reference

fernandotoledo — Wed, 30 Jun 2010 14:47:23 GMT

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.

What is the difference between loosely coupled circular reference

Thu, 22 Jul 2010 13:03:54 GMT

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/

What is the difference between loosely coupled circular reference

syed_muzammil — Thu, 22 Jul 2010 16:42:29 GMT

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 .

What is the difference between loosely coupled circular reference

Fri, 23 Jul 2010 05:13:24 GMT

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?