loosely coupled tables?

[Anonymous]

Hi I have,

t1:

load * inline [

a,b

1,11

2,22

];

t2:

load * inline [

b,c

3,33

4,44

];

t3:

c,a

5,55

6,66

];

how to remove circular reference using loosely coupled tables ?

what is the use of loosely coupled tables here?

if i use loosely coupled statment in script level still my relation ship between tables with dotted lines only ?

[#2]

Hi commonqlik,

check this, i think its useful,

Circular References

[vikasmahajan]

See this link https://community.qlik.com/thread/104017

Vikas

[#4]

Hi

Loosely coupled tables and circular references go hand in hand and you should try and avoid them. It happens when  3 or more tables with a circular reference is loaded into Qlikview

You can remove the circular reference by renaming fields that are not primary keys (used to link 2 tables)

In your case rename field 'a' in t3 to something else

t1:

load * inline [

a,b

1,11

2,22

];

t2:

load * inline [

b,c

3,33

4,44

];

t3:

load * inline [

c,aa

5,55

6,66

];

[Chanty4u]

chk dis

Re: loosely coupled tables

How to "Loosely Couple" a Table?

Re: What exactly is Loosely Coupled Table ?

[Kushal_Chawda]

see this

Circular References

[settu_periasamy]

Have you read this  Circular References

"There are several solutions to prevent such loops like the concatenate function or link table. Although the best solution to fix circular references depend on the situation" - Source Here‌‌‌

Example from Circular References

[Person-Car]:
LOAD * INLINE [
    Person, Car
    Albert, Valvo
    Herbert, SAAB
];
[Car-City 1]:
LOAD * INLINE [
    Car, City Where card is Made
    Valvo, Gothenburg
    SAAB, Trollhattan
];
[Person-City]:
LOAD * INLINE [
    Person, City
    Albert, Trollhattan
    Herbert, Gothenburg
];
[Car-City 2]:
LOAD * INLINE [
    Car Produced in City, City
    Valvo, Gothenburg
    SAAB, Trollhattan
];

May be try the same method in your data like

t1:
load * inline [
  a,b
  1,2
  2,1
];
t2:
load * inline [
  b,c
  2,33
  1,44
];
t3:
LOAD * Inline [
  c,d
  33,55
  44,66
];
t4:
load * inline [
  a1,d
  1,55
  2,66
];

[engishfaque]

Dear CommonQlik,

Here is the way,

Open your QlikView App and Go to Menu > Settings > Document Properties > Tables > Checked/Unchecked to your Loosely Coupled Table > Apply > OK.

Kind regards,

Ishfaque Ahmed