topic Avoiding circular loop in the datamodel in QlikView

Avoiding circular loop in the datamodel

divya_anand — Thu, 29 Jun 2017 11:05:55 GMT

Hi All,

I am working with a complex datamodel and just to give you an idea I am highlighting in the below picture only the areas of interest in the datamodel. As you can see, the tables are connected as shown with various keys. All these connections are important. Now I have 2 fields (C & D in this case) which is basically the CodeNo & has to be linked. So, clearly that would create a circular loop and joining or concatenating tables (Table1, Table2, Table3, Table4) is not an option for me for this datamodel.

Any other idea that clicks your mind? Please let me know.

Thank you.

Re: Avoiding circular loop in the datamodel

swuehl — Thu, 29 Jun 2017 11:14:09 GMT

That's hard to answer without knowing your data model and requirements in detail.

You probably know that you can keep both fields unlinked, if they mean something semantically different, as discussed in

Circular References

Then just rename CodeNo in one of the tables.

Re: Avoiding circular loop in the datamodel

prat1507 — Thu, 29 Jun 2017 11:26:47 GMT

Hi Divya

Table1 is already linked to Table4 in the data model given. You can rename the field D which is CodeName as something else. I think they would still be linked as per the fields you've used in your data model.

Regards
Pratyush

Re: Avoiding circular loop in the datamodel

divya_anand — Tue, 04 Jul 2017 12:26:25 GMT

Hi Stefan,

Thank you for the response. I agree that it's difficult to answer such questions without QVW.

I'll try to work around the logic mentioned in the link you provided.

Thank you.

Re: Avoiding circular loop in the datamodel

divya_anand — Tue, 04 Jul 2017 12:30:47 GMT

Hi Pratyush,

Thank you for the response.

I understand your point, that's what I thought too when I saw the datamodel. But the datamodel I am dealing with seems very different.

Anyways, Let me try this out and see.