Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

How to "Loosely Couple" a Table?

Hi there,

I have been going through the QV Reference Manual (ver 11) and read the "Loosely Coupled Tables" chapter(page 118)

I have created the first example shown in this chapter in order to try and "loose couple" Tab 2 as requested in the example, but I honestly don't know how to do so.

In short - how do i loosely couple tab 2 for that matter?

the file with the specific example is attached.

Once again, thanks in advance for your help..

1 Solution

Accepted Solutions
mov
Esteemed Contributor III

Re: How to "Loosely Couple" a Table?

There are two ways to loosen a table

1. In the script - use statement:

LOOSEN Tab2;

2. On the front end - in document prioperties, tab Tables, find your Tab2 in the first column, and check the box "Loosely coupled"

Regards,

Michael

NOTE: if you loosen a table in the script, you can't uncheck the box on the front end.

5 Replies
lironbaram
Honored Contributor II

Re: How to "Loosely Couple" a Table?

hi attch is an example

shree909
Valued Contributor II

Re: How to "Loosely Couple" a Table?

can u explain it briefly...

i am confused..

mov
Esteemed Contributor III

Re: How to "Loosely Couple" a Table?

There are two ways to loosen a table

1. In the script - use statement:

LOOSEN Tab2;

2. On the front end - in document prioperties, tab Tables, find your Tab2 in the first column, and check the box "Loosely coupled"

Regards,

Michael

NOTE: if you loosen a table in the script, you can't uncheck the box on the front end.

Not applicable

Re: How to "Loosely Couple" a Table?

Hi there and thank you!

Michael - Thanks for your well put together answer.

Liron - Thanks for your reply example.

Both did help me understand the technical part of this subject.

I still need to understand one more thing I'm finding hard to understand, in the matter of logic understanding - why does Tab 2 is changing its formation after loosely coupling is taking action? how did it became a some what of a "statistics table" (not a QV statistic table) that shows all possibilities of combinations between the variables?

Hope i made my point clear.

Would be glad for an answer. thanks!

mov
Esteemed Contributor III

Re: How to "Loosely Couple" a Table?

That's what the "loosen" does.

In fact, it works differently in the different QV versions.  I used this feature successfully in QV 7.x, where loosely coupled tables were affected by selections in the other tables, but selections in the loosen table didn't affect anything outside it.  The functionality was changed in later versions, and in different ways in different versions.  I didn't use it since than, and can't tell where it may be needed.

In any case, be very careful about using this option.  A good amount of testing is needed to make sure you get what you want.

Regards,

Michael

Community Browser