What is Circular Reference?

[#1]

Hi All,

I am new to Qlikview.May i know the exactly circular reference in my data model.I went through articles but i'm still confusing.So any one can explain in detail.

Thanks in Advance

Hita

[its_anandrjs]

Hi,

Let assume simple tables where we have the Regions, City, Budget and Sales information in the tables. In first tables the data from Table A and B is referenced with the Region field. But in the C table there is two field they refer to individually A and B but as A and B are refer to field also. Then in this condition there is the circular reference crated.

In this below post Henric explain very well

http://community.qlik.com/blogs/qlikviewdesignblog/2013/06/25/circular-references

See this example

A:

LOAD * Inline [

Region,City,Sales

R1,c1,458962

R2,c2,266582 ];

B:

LOAD * Inline [

Region,Cityies,Budget

R1,c1,4562

R2,c2,4563 ];

C:

LOAD * Inline [

Cityies,Sales

C1,458

C2,1255 ];

Regards,

Anand

[Anonymous]

Hi Hita,

A Circular reference (also called Circular loop) happens when one table is reachable by two or more ways.

Circular reference can be avoided in the following ways –

1) Rename a column.

2) Use Qualify

3) Concatenating Several Tables into One.

Below is henric post, it is very useful:

Circular  reference

Regards

Neetha