What exactly is Loosely Coupled Table ?

[nikhilgarg]

Hi,

Whenever we encounter a circular loop, Loops may cause ambiguous results and should therefore be avoided. QlikView will cut the loop(s) by setting one or more tables as loosely coupled. I have gone thru different posts but don't know what exactly is loosely coupled table. Can anyone help me out?

Thanks

[Gysbert_Wassenaar]

Please search before posting a question: https://community.qlik.com/search.jspa?q=loosely+coupled+table

This blog post explains the concept: Circular References

[#3]

Suppose your tables relation in qlikview like TABLE_A to TABLE_B, TABLE_B to TABLE_C and TABLE_C to TABLE_A

then you can get the circular reference, it causes the ambiguous, it doesn't give the correct result from the tables and also it stops the script execution, that situation you also need to execute the script without failing need the tables loaded ad loosen  tables.

LOOSEN Tables TABLE_A, TABLE_B, TABLE_C; (End of the script)

Regards

AR UMAMAHESH

[nikhilgarg]

Hey,

Let me sum up what is understood:

If we have cicular references as:

Table1 -> Table2 -> Table3 -> Table1

Now if i make Table2 as loosely coupled then it means that logical inference will not be propagated from

Table2 which means from table 2 no linking to other fields in other table will be there.So, our scenario will look like:

Table3 -> Table1 -> Table2

Am i correct ?

[nikhilgarg]

Hey,

Let me sum up what is understood:

If we have cicular references as:

Table1 -> Table2 -> Table3 -> Table1

Now if i make Table2 as loosely coupled then it means that logical inference will not be propagated from

Table2 which means from table 2 no linking to other fields in other table will be there.So, our scenario will look like:

Table3 -> Table1 -> Table2

Am i correct ?

[#6]

I think we may need to mention all the table names which are involved in  circular refference in LOOSEN TABLES script

[#7]

Hi,

Refer the link for details.

What is loosen table and link table?