topic Help: Circular Loop in QlikView

Help: Circular Loop

Tue, 05 Jun 2012 07:56:32 GMT

Hi All,

Please help me how to eliminate this circular loop, when I try to connect the table in red box to the calendar it produces a circular loop.

Tue, 05 Jun 2012 08:13:34 GMT

Hi Mars,

have you tried to rename DateKey in one of the table and duplicate the same field in the other table!?

I mean:

In FiscalCalendar table you duplicate DateKey so you have DateKey and DateKey_2.

In WattTransaction rename DateKey to DateKey_2

I don't know your goal so maybe it's not correct but you can try.

Hope it helps

Giampiero

Tue, 05 Jun 2012 23:25:00 GMT

it still produces circular loop.. any other advice??

Wed, 06 Jun 2012 07:23:18 GMT

I see,

the problem is "CmboMapp..." Table.

Try to avoid the link between WattTransaction and ComboMapp tables (renaming in WattTransaction table the field Output_LINK)

In this way you should have these links:

Ledger --> FiscalCol --> WattTransaction and Ledger-->ComboMapp...

Again, I don't know your goal so maybe this is not the right solution but you'd want produce circular loop.

Hope that helps

Giampiero