Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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:
Regards
Neetha