Circular loop errors?

[Anonymous]

Hi

I have attached my qv file.

I need to display the sum of tickets resolved by a user from two different dumps from which the user needs to be identified.

TR Dump - User is identified from the Problem Owner field.

Incident Dump - User is identified from the Assignee Field.

When I am trying to link the New_Owner field between the both the dumps I get an error stating 'circular ambiguous loops...' and the file does not get executed.

Can anybody help as to what is going wrong with my script?

[Anonymous]

Did you check this?

Circular References

How to avoid circular loops in the Qlikvew Data model

[ramasaisaksoft]

Hi Sanjyot,

my suggestion is to remove New_temp table .

concatenate New_temp  with Tr_Dump so that this circular loop will remove.

i hope it will clear your issue.

[Anonymous]

Hi Rama

If I drop New_Temp table how will I use maptable function to identify the users from the TR dump. I need to identify these as well...Any suggestions?

[jonathandienst]

I suggest that you read the following articles:

Get started with developing qlik datamodels

Advanced topics for creating a qlik datamodel‌

More advanced topics of qlik datamodels

[sujeetsingh]

Seems you are putting in your hands without knowing the depth!

Well just before you try building your data model for the application first of all know the tables you need and how or which key field is to link them. It should be not the case that you link any table with all keys or fields available.

* remove synthetic keys first if needed use link tables

* rename the field creating circular look if cant then join the two tables and make them one will remove the loop

But before you move on I will recommend you first know the depth and basics of data modeling.

Best Practices for Data Modelling