Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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

3 Replies
marcus_sommer

Have a look here:

Circular References

Synthetic Keys

- Marcus

Peter_Cammaert
Partner - Champion III
Partner - Champion III

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.

fkeuroglian
Partner - Master
Partner - Master