topic Circular reference on my model in QlikView

Circular reference on my model

Fri, 06 Mar 2015 13:52:05 GMT

Hello,

I was having a Circular Reference problem while creating my data model, then I renamed a field and the warning of this problem just stopped, but when I look at my table viewer both of models seem to have a circular reference.

Can someone explain me why the in second image I have a circular reference and in the first one I don't?

Re: Circular reference on my model

its_anandrjs — Sat, 07 Mar 2015 06:37:52 GMT

Hi,

Try to rename the field that create the circular loop or weather check if possible take one of the table in another table by concatenate the tables.

Regards

Anand

Re: Circular reference on my model

MK_QSL — Sat, 07 Mar 2015 06:45:01 GMT

Change as below in your load script..

CustomerTable

RETAILER_CODE as RETAILER_CODE1

Re: Circular reference on my model

its_anandrjs — Sat, 07 Mar 2015 06:53:06 GMT

Hi,

Another possible ways is

1. Do not use RETAILER_CODE in branch table remove there or rename here in the branch table like

branch:

Load

RETAILER_CODE as Brach_RETAILER_CODE

From Source;

2.Use RETAILER_CODE via FullOrdersCognos table no need to keep RETAILER_CODE in two tables

Regards

Anand

Re: Circular reference on my model

mukesh24 — Sat, 07 Mar 2015 09:51:48 GMT

Hi Cesar,

In Second image having circular reference because assume following scenario:-

Table A -- Table B Table C

Key1 Key1 Key2

Key3 Key2 Key3

when u link table A with B (Linkage between to suppose Key1)

B Table link with another table C(linkage with Key2)

C automatically link with Table A through Key3

In above case circular reference occure. Same thing happen in your case.

In first Image If you check Synthetic Key occure.

Regards,

Mukesh Chaudhari

Re: Circular reference on my model

Mon, 09 Mar 2015 21:34:35 GMT

Thank you Mukesh Chaudhari!!