Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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

Re: How to avoid circular references in qlikview?

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

Re: How to avoid circular references in qlikview?

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

Employee
Employee

Re: How to avoid circular references in qlikview?

Hi madhu,

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

Cheers

Carlos

Re: How to avoid circular references in qlikview?

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....

Re: How to avoid circular references in qlikview?

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;

Re: How to avoid circular references in qlikview?

Re: How to avoid circular references in qlikview?

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];

Community Browser