Table Looping in Data Model Structure

[tashtashtash]

Hi All,

I'm in the process of creating a data model for our NetSuite application, however I'm coming across a data looping messaging when reloading the model

In NetSuite all the transactions like Opportunity, Quote etc are all stored in one table, in QlikView I have split them off into separate "types" so I can join them, this works

I join on "Transaction Lines" which is a table that stores all the lines on these transactions, here the loop occurs because I join this table to all the transaction tables above, the idea is to get the line items of each of the types of transactions because they could vary between types

How would I resolve this loop?

I can keep the transactions in one table, but then how do I link the rows to themselves as there are relationships in this one table

Many Thanks

[alex00321]

Hi Maybe you could post sample file so we could help. Thanks!

[Brett_Bleess]

A screenshot would really help, but I think what you are most likely running into is a circular reference.  Here is a link to the Design Blog area and a post on how to deal with those:

https://community.qlik.com/t5/Qlik-Design-Blog/Circular-References/ba-p/1469332

Regards,
Brett