topic Re: Circular Reference in QlikView

Circular Reference

Fri, 12 Jun 2015 11:14:46 GMT

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

Re: Circular Reference

fvelascog72 — Fri, 12 Jun 2015 11:17:20 GMT

Hi,

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

Re: Circular Reference

giakoum — Fri, 12 Jun 2015 11:18:05 GMT

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

Re: Circular Reference

sunny_talwar — Fri, 12 Jun 2015 11:18:34 GMT

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

Re: Circular Reference

Anonymous — Fri, 12 Jun 2015 11:27:51 GMT

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

Re: Circular Reference

Fri, 12 Jun 2015 12:03:55 GMT

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