topic Re: How to avoid circular references in qlikview? in QlikView

How to avoid circular references in qlikview?

Sun, 01 Jun 2014 05:44:25 GMT

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

Re: How to avoid circular references in qlikview?

its_anandrjs — Sun, 01 Jun 2014 05:59:02 GMT

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.

Re: How to avoid circular references in qlikview?

Sun, 01 Jun 2014 06:05:21 GMT

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

Re: How to avoid circular references in qlikview?

cfz — Sun, 01 Jun 2014 06:07:19 GMT

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?

robert_mika — Sun, 01 Jun 2014 07:05:41 GMT

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?

its_anandrjs — Sun, 01 Jun 2014 08:18:04 GMT

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?

MarcoWedel — Sun, 01 Jun 2014 08:27:28 GMT

Very nice description:

http://community.qlik.com/blogs/qlikviewdesignblog/2013/06/25/circular-references

by henric cronström

http://community.qlik.com/people/hic

hope this helps

regards

Marco

Re: How to avoid circular references in qlikview?

its_anandrjs — Sun, 01 Jun 2014 08:46:57 GMT

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