topic Re: Circular Loop Is there any one to help me here ? struggling...Anand Chouhan where are you ? in QlikView

Circular Loop Is there any one to help me here ? struggling...Anand Chouhan where are you ?

Sun, 15 Feb 2015 18:13:03 GMT

Hi Everybody,

iam attaching a snap shot of the data model in which u can see the looping

There are totally 5 tables .

Zbkreg is connected to proje using cosolidation key ( a column name ) and proje is connected to prps using project def Prps,

object number is connecting Prps with Cosb and real billing table .

In real billing table there is one more column name (Field Name) ad Date , and there is a field name as date in ZBKREG table,

Its creating a llop now , i dont want to comment any of the field nor i want to rename because the real billing table has to be connected to zbkreg using Date field and as well as the real billing should be connected to even COSb and Prps using object number.

can someone plz help meeeee

Re: Circular Loop

marcus_sommer — Sun, 15 Feb 2015 19:03:47 GMT

Have a look here:

Circular References

Synthetic Keys

- Marcus

Re: Circular Loop Is there any one to help me here ? struggling...Anand Chouhan where are you ?

Peter_Cammaert — Sun, 15 Feb 2015 20:06:49 GMT

If you don't want to change anything (a bit odd if you ask me), then choose another table to make "loosely coupled", like zbkreg itself. You can do this in Settings->Document Properties->Tables. A loosely coupled table will not transmit selections to the other side and thus avoid endless selection loops.

Re: Circular Loop Is there any one to help me here ? struggling...Anand Chouhan where are you ?

fkeuroglian — Sun, 15 Feb 2015 20:47:14 GMT

see this link, hope helps

Circular References

How circular reference can be avoided?

How to remove circular reference