Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

nihhalmca
Valued Contributor II

Loosely Couple Table

Hi All,

When will we use 'Loosen' keyword in edit script.

How it is useful for data modeling. Which scenarios Loosely couple table will use.

Can anybody give examples on this.

Thank you.

Regards,

Nihhal.

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: Loosely Couple Table

Hi,

Check this

Table1:

LOAD

*

INLINE [

A, B

1, 2 ];

Table2:

LOAD

*

INLINE [

C, B

1, 2 ];

Table3:

LOAD

*

INLINE [

C, A

1, 2 ];

Loosen Table Table3;

By using Loosen Table Table3; you won't get the error message regarding the circular loop.

Regards,

Jagan.

View solution in original post

9 Replies
pradeepreddy
Valued Contributor II

Re: Loosely Couple Table

go through the link...

Re: How to "Loosely Couple" a Table?

Not applicable

Re: Loosely Couple Table

Hi,

If you have circular reference in your data model in this case u can use loosen tables.

suppose if you have circular refference between A,B,C

then use this command in the script after load statement of all the tables.

Loosen tables A,B,C;

it will give good performance if you have circular refference also

nihhalmca
Valued Contributor II

Re: Loosely Couple Table

Hi Rakesh,

Thanks for response.

Can you give share sample qvw.

MVP & Luminary
MVP & Luminary

Re: Loosely Couple Table

Hi,

Check this

Table1:

LOAD

*

INLINE [

A, B

1, 2 ];

Table2:

LOAD

*

INLINE [

C, B

1, 2 ];

Table3:

LOAD

*

INLINE [

C, A

1, 2 ];

Loosen Table Table3;

By using Loosen Table Table3; you won't get the error message regarding the circular loop.

Regards,

Jagan.

View solution in original post

Re: Loosely Couple Table

If you have "Loosley Coupled" tables, and a circular reference then your data model is incorrect and you should fix the problem by correctly linking the tables.

Using "Loosen" is not a fix for an incorrect data model.

Not applicable

Re: Loosely Couple Table

Hi,

Sorry I Dont have any sample application for loosen concept.

nihhalmca
Valued Contributor II

Re: Loosely Couple Table

Its Ok Rakesh.

MVP & Luminary
MVP & Luminary

Re: Loosely Couple Table

Hi Nihhal,

Having Loosely coupled tables is not a good practice to avoid Circular loop issue, it is a quick fix but not the efficient one.  Try to avoid loop by using various techniques like Link Table, Concatenate, Renaming field etc.

Hope this helps you.

Regards,

Jagan.

Highlighted
nihhalmca
Valued Contributor II

Re: Loosely Couple Table

Hi All,

Just check Loosely couple option after followed by Jagan mohan answer (shown as correct answer). see below steps to check Loosely couple option.

Settings -- Document properties -- table -- check Loosely couple option for required table.

Regards,

Chittibabu.