topic Re: What exactly is Loosely Coupled Table ? in QlikView

What exactly is Loosely Coupled Table ?

nikhilgarg — Fri, 14 Aug 2015 09:21:24 GMT

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

Re: What exactly is Loosely Coupled Table ?

Gysbert_Wassenaar — Fri, 14 Aug 2015 09:26:05 GMT

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

This blog post explains the concept: Circular References

Re: What exactly is Loosely Coupled Table ?

Fri, 14 Aug 2015 09:35:47 GMT

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

Re: What exactly is Loosely Coupled Table ?

nikhilgarg — Fri, 14 Aug 2015 09:36:56 GMT

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 ?

Re: What exactly is Loosely Coupled Table ?

nikhilgarg — Fri, 14 Aug 2015 09:39:26 GMT

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 ?

Re: What exactly is Loosely Coupled Table ?

Fri, 14 Aug 2015 10:02:08 GMT

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

Re: What exactly is Loosely Coupled Table ?

Fri, 14 Aug 2015 10:17:58 GMT

Hi,

Refer the link for details.

What is loosen table and link table?