topic How to "Loosely Couple" a Table? in QlikView

How to "Loosely Couple" a Table?

Sun, 29 Jul 2012 10:46:01 GMT

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..

Re: How to "Loosely Couple" a Table?

lironbaram — Sun, 29 Jul 2012 11:29:48 GMT

hi attch is an example

Re: How to "Loosely Couple" a Table?

shree909 — Sun, 29 Jul 2012 17:50:00 GMT

can u explain it briefly...

i am confused..

Re: How to "Loosely Couple" a Table?

Anonymous — Sun, 29 Jul 2012 18:23:08 GMT

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.

Re: How to "Loosely Couple" a Table?

Sun, 29 Jul 2012 18:59:21 GMT

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!

Re: How to "Loosely Couple" a Table?

Anonymous — Mon, 30 Jul 2012 10:29:34 GMT

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