Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
Not applicable

Circular reference on my model

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?


IMG_05032015_164921.png


Tags (1)
1 Solution

Accepted Solutions
Partner
Partner

Re: Circular reference on my model

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

View solution in original post

5 Replies

Re: Circular reference on my model

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

MVP
MVP

Re: Circular reference on my model

Change as below in your load script..

CustomerTable

RETAILER_CODE as RETAILER_CODE1

Re: Circular reference on my model

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

Partner
Partner

Re: Circular reference on my model

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

View solution in original post

Not applicable

Re: Circular reference on my model

Thank you Mukesh Chaudhari!!