topic Re: Circular loop errors? in QlikView

Circular loop errors?

Anonymous — Thu, 16 Jun 2016 12:00:59 GMT

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?

Re: Circular loop errors?

Anonymous — Thu, 16 Jun 2016 12:04:37 GMT

Did you check this?

Circular References

How to avoid circular loops in the Qlikvew Data model

Re: Circular loop errors?

ramasaisaksoft — Thu, 16 Jun 2016 13:31:20 GMT

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.

Re: Circular loop errors?

Anonymous — Fri, 17 Jun 2016 04:35:33 GMT

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?

Re: Circular loop errors?

jonathandienst — Fri, 17 Jun 2016 05:20:18 GMT

I suggest that you read the following articles:

Get started with developing qlik datamodels

Advanced topics for creating a qlik datamodel‌

Re: Circular loop errors?

sujeetsingh — Fri, 17 Jun 2016 05:30:47 GMT

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