topic Re: loops error in App Development

loops error

Thu, 19 Nov 2015 15:11:45 GMT

hello i got this message of loops problem any suggestions how to fix a loop problem ,

i have alot of script lines....

Thu, 19 Nov 2015 15:19:57 GMT

this might indicate the problem?

oknotsen — Thu, 19 Nov 2015 15:49:44 GMT

Loops are not allowed in your data model.

So either cut the key connection between any 2 of the 3 tables or see if you can join those 2 dimensions.

reddy-s — Thu, 19 Nov 2015 17:29:08 GMT

Hi Jhonatan,

You can get rid of circular references by renaming the SALES_KEY field in the INV_SALES table if you do not need an association between them.

Instead you can even join the CUSTOMERS table and the INV_SALES table together and create a composite key to join it to the KEY_TABLE.

There is a lot to say here so please go through this document : Circular References by HIC.

- Sangram

Josh_Good — Fri, 20 Nov 2015 00:56:40 GMT

Hi,

This video by mto‌ should help explain what is happening.

You may also wish to take a look at Creating a Data Model‌

-Josh

Qlik