topic Re: Table Looping in Data Model Structure in QlikView

Table Looping in Data Model Structure

tashtashtash — Sat, 16 Nov 2024 19:16:58 GMT

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

Re: Table Looping in Data Model Structure

alex00321 — Tue, 21 Jan 2020 08:27:51 GMT

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

Re: Table Looping in Data Model Structure

Brett_Bleess — Thu, 13 Feb 2020 16:15:36 GMT

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