Will circular reference improve the Qlikview Document?

[subin6600]

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

[SunilChauhan]

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.

[subin6600]

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

Thanks a lot Sunil

[#4]

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]

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 · Accepted solution]

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