Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Circular Reference

Hi

Below is my Table Viewer Snapshot.

When i link ALT1 in AMSR_Apr and ALT_DATE in sheet 1 i get a circular Reference.

How do i avoid that

Regards

Senthil

5 Replies
fvelascog72
Partner - Specialist
Partner - Specialist

Hi,

In the image I can´t see any circular reference.

giakoum
Partner - Master II
Partner - Master II

do you mean a synthetic key?

create a composite key with the fields you need to link and drop them from one of the 2 tables

sunny_talwar

Why don't you join Sheet1 into the Dept_Master (Script Join) and then I think you will have two tables with two fields they link on. I feel that should help.

Best,

Sunny

Anonymous
Not applicable
Author

if you really need to join AltAct1 and Date1

can you rename country_code as country_codeSh column in Sheet table.

and also add one more column in AMSR table  country_code as country_codeSh

AltAct1 as Date . it will create a Sync key but remove Circular reference .

for removing sync key you can concat  fields country_code & AltAct1 as Key2 in both the table.

Now you will not get any sync key not circular ref.


Thanks

BKC

Not applicable
Author

Hi

Sheet has got data on a daily basis and Dept Master is a master table, so i think joining is not possible