topic Re: loosely coupled tables? in QlikView

loosely coupled tables?

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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 ?

Re: loosely coupled tables?

Fri, 15 Apr 2016 04:22:21 GMT

Hi commonqlik,

check this, i think its useful,

Circular References

Re: loosely coupled tables?

vikasmahajan — Fri, 15 Apr 2016 04:27:53 GMT

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

Vikas

Re: loosely coupled tables?

Fri, 15 Apr 2016 04:35:36 GMT

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

];

Re: loosely coupled tables?

Chanty4u — Fri, 15 Apr 2016 04:52:21 GMT

chk dis

Re: loosely coupled tables

How to "Loosely Couple" a Table?

Re: What exactly is Loosely Coupled Table ?

Re: loosely coupled tables?

Kushal_Chawda — Fri, 15 Apr 2016 05:26:28 GMT

see this

Circular References

Re: loosely coupled tables?

settu_periasamy — Fri, 15 Apr 2016 05:28:16 GMT

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
];

Re: loosely coupled tables?

engishfaque — Fri, 15 Apr 2016 05:34:44 GMT

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