topic Re: What is Circular Reference? in QlikView

What is Circular Reference?

Mon, 24 Nov 2014 17:45:13 GMT

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

Re: What is Circular Reference?

its_anandrjs — Mon, 24 Nov 2014 18:20:00 GMT

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

LOAD * Inline [

Region,City,Sales

R1,c1,458962

R2,c2,266582 ];

LOAD * Inline [

Region,Cityies,Budget

R1,c1,4562

R2,c2,4563 ];

LOAD * Inline [

Cityies,Sales

C1,458

C2,1255 ];

Regards,

Anand

Re: What is Circular Reference?

Anonymous — Mon, 24 Nov 2014 18:26:06 GMT

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