Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
subin6600
Creator III
Creator III

Will circular reference improve the Qlikview Document?

Can anyone explain what is circular reference, and how it affects/helps the qlikview report?

1 Solution

Accepted Solutions
its_anandrjs

Hi,

Circular reference is created due to some fields that are creating loop ammong the tables when theu are all ready connected with any key and one of its fields having same name so it got reference to the field and they create a circular reference.

It is good if you avoid it it is not good to remove circular reference try rename the field or try to map or give different name to the tables like use Qualify * ; command like

Table1:

load statement

Qualify *;

Table2:

load statement

Unqualify *;

After this code all table fields name start with table name like Table2.yourfield etc rest of the fields come same order

Rgds

Anand

View solution in original post

5 Replies
SunilChauhan
Champion
Champion

Circular reference is problem for qlikview. it prompt to show wrong figures.

it need to remove from ur application.

to remove break one link between table which not use full and not affect your result.

Cause: when multiple table link so that they make a link .it creates circular reference.

Sunil Chauhan
subin6600
Creator III
Creator III
Author

Ok. So we should always try to avoid Circular reference in our Qlikview Structure.

Thanks a lot Sunil

Not applicable

circular reference is created when there is a loop, we should always try to avoid circular references.

you can remove circular reference by renaming the fields and also by using mapping.

kamalqlik
Partner - Specialist
Partner - Specialist

Circular refrence are generally ceated when there is a loop type structure in data model ie the field are linked to one other in form of loop in the diffrent tables.

In qlikview we should avoid circular refrence,because they effect a lot in the processing and sometimes also the unmatchable data.

we can remove them by using aliasing,mapping,joining etc.

its_anandrjs

Hi,

Circular reference is created due to some fields that are creating loop ammong the tables when theu are all ready connected with any key and one of its fields having same name so it got reference to the field and they create a circular reference.

It is good if you avoid it it is not good to remove circular reference try rename the field or try to map or give different name to the tables like use Qualify * ; command like

Table1:

load statement

Qualify *;

Table2:

load statement

Unqualify *;

After this code all table fields name start with table name like Table2.yourfield etc rest of the fields come same order

Rgds

Anand