Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
arulsettu
Master III
Master III

loosely coupled tables

Hi i am very new to qlikview can any one explain what is the use of loosely coupled tables with example

thanks in advance...

13 Replies
Anonymous
Not applicable

Not applicable

hi, check this out!!!

How to "Loosely Couple" a Table?

arulsettu
Master III
Master III
Author

can any one explain this with simple scenario...

Siva_Sankar
Master II
Master II

read the "Loosely Coupled Tables" chapter(page 118). attached is the reference manual.

Regards.

Siva

Anonymous
Not applicable

The best way to deal with the loosely coupled tables is to avoid using them.

marcus_malinow
Partner - Specialist III
Partner - Specialist III

Agreed in most circumstances, however I saw an interesting article the other day about using loosely coupled tables in a security model. Wish I could find it now though...

Anonymous
Not applicable

Marcus Malinow,

I built a quite complex application using this loosely coupled tables many years ago.  As a result, client can't use this application in the newer QV versions because the behavior of the loosely coupled tables has changed , and more than once , and in the different ways .  So, I'm not touching this feature anymore.  Especially now, when QV has set analysis so we can ignore selections in a more reliable way.

Regards,

Michael

Not applicable

arul: do you know what Circular references are? Perhaps you should start there.

Anonymous
Not applicable

Loosely coupled tables are created automatically when the data model(3 or More Tables) that includes circular references is loaded into QlikView,to avoid them the circular references create a loop in the QlikView internal logic. These loosely coupled tables need to be handled in order to visualize data in a way that is expected and understandable.

See Article  Circular References

Any table can also be made loosely coupled interactively from this dialog or via macros. Additionally, it is possible to declare loosely coupled tables explicitly in the script via the Loosen Table statement.

The normal QlikView associative logic is disconnected internally for loosely coupled tables. This means that selections in one field do not Associate through to the other  fields in the table. its very useful to avoid circular references in the data structure in various scenarios. For more examples of how this feature can be used, please refer to the  QlikView Reference Manual - Intentionally Creating Loosely Coupled Tables


One or more QlikView internal data tables can be explicitly declared loosely coupled during script execution by using a Loosen Table statement.

The use of one or more Loosen Table statements in the script will make QlikView disregard any setting of tables as loosely coupled made before the script execution.

The syntax is:

Loosen Table tablename [ , tablename2 ...]

Either syntax: Loosen Table and Loosen Tables can be used.

Example:

Table1:

Select * from Trans;

Loosen table Table1;

Note!
Should QlikView find circular references in the data structure which cannot be broken by tables declared loosely coupled interactively or explicitly in the script, one or more additional tables will be forced loosely coupled until no circular references remain. When this happens, the Loop Warning dialog, gives a warning.