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: 
Not applicable

How to avoid circular references in qlikview?

hi guys,

I  reload script in Qlikview it show circular references. I do not know  how to avoid that circular references I want to avoid that circular references please tell me out how to avoid circular references in qlikview. I attached  snipping files below this box.

  Regards:

  Madhu

Circular Reference script.PNG.pngCircular Reference Table viewer.PNG.png

7 Replies
its_anandrjs

Rename your field name which is creating circular references or make the composite keys from the keys

1. Rename the fields which are creating the circular references.

2. Join two tables based on the keys and use only two tables join the tables based on the relation primary key table or transaction table.

Eg:-

city_car:

LOAD * Inline

[

city,car

Mum,SomeCar

];

Left Join(city_car)

person_car:

LOAD * Inline

[

car,person

SomeCar,A

];

Left Join(city_car)

person_city_Master:

LOAD * Inline

[

city,person

Mum,A

];

Note:- There are many ways to doing the same problem.

Not applicable
Author

Thanks Anand chouhan .I want to use Loosen Table statement please tell me out and explain with example chouhan.

cfz
Former Employee
Former Employee

Hi madhu,

Try loading one of the tables twice changing one of the fields names each of the times.

Cheers

Carlos

robert_mika
Master III
Master III

Why are you splinting your data anyway?

If you need to change the name try like this:

Person_car

LOAD

car as Pcar,

Person as Pperson

FROM....

its_anandrjs

Hi,

Use Loosen table with one of the tables for avoiding the circular references when you reload by above script you dont get the message circular reference.

city_car:

LOAD * Inline

[

city,car

Mum,Hyundai

];

//LOOSEN Table city_car;

person_car:

LOAD * Inline

[

car,person

Hyundai,A

];

person_city:

LOAD * Inline

[

city,person

Mum,A

];

LOOSEN Table person_city;

MarcoWedel

its_anandrjs

For more simplify you can break table into more informative ways and use that tables to normalize the tables. In the documentation Henric explain this also take a look at the sample load script for this.

city_car:

LOAD * Inline

[city,car

Mum,Hyundai];

/////

car_details:

LOAD

city,car as [Car in the city]

Resident city_car;

city_Details:

LOAD

city as [City of the Car],car

Resident city_car;

DROP Table city_car;

/////

person_car:

LOAD * Inline

[car,person

Hyundai,A];

person_city:

LOAD * Inline

[city,person

Mum,A];