topic avoiding a circular reference loop in QlikView

avoiding a circular reference loop

Fri, 30 Jul 2010 16:35:14 GMT

Hi,

Im having a problem with a circular loop reference when i try and link 'Care Group' field in 3 tables.

I therefore have to rename 'Care Group' to 'Specialty Care Group' in the Specialty_Mapping table to prevent this loop. The thing is without these both linking i cant display any relationships between the 3 tables in charts.

The image below illustrates the 3 fact tables (circles black) and the 2 fields hightlighted green are the fields i want to link by common 'Care Group name' but if i do the loop appears.

Does anyone have any thoughts on how i can prevent such a loop?

avoiding a circular reference loop

Fri, 30 Jul 2010 16:42:08 GMT

create a unique field incorporating all the linked fields

e.g. field_a & field_b & field_c as uni_field

avoiding a circular reference loop

Fri, 30 Jul 2010 16:58:02 GMT

Hi what unique key do you propose based on diagram attached?

avoiding a circular reference loop

Fri, 30 Jul 2010 18:15:12 GMT

Qlikview creates a link/join by matching field names in each table, if you want to avoid circurlar reference and link two tables then create a common field that is only common to those two tables.

e.g. if you have thre tables A, B, C, each table contains a field called customer. If you only want to join only tables A & B then create a field while loading the script of tables A & B

customer as customer_AB,

In your example you have a number of fields with the exact same, rename the fields unique (the ones you don't want to join on) to that table as you load the table otherwise a circular reference occurs. If you do want to link all of these common fields then you can create a master table like this:

LOAD * FROM TABLE_A;

CONCATENATE

LOAD * FROM TABLE_B;

CONCATENATE

LOAD * FROM TABLE_C;