topic Re: One or more loops have been detected in your database structure. in QlikView

One or more loops have been detected in your database structure.

Luke_Killer_IT — Fri, 27 Aug 2021 07:55:50 GMT

hi,

I have an awfully big problem it is that I create a loop and I would like to eliminate it

the problem is that v_beleinfo 100 and vBeleg info 300 must be connected to the calendar and e_belgpos

Re: One or more loops have been detected in your database structure.

Vegar — Fri, 27 Aug 2021 08:08:16 GMT

I notice the two tables look quite similar. What if you concatenate the 100 and 300 tables into one and distinguish the two by adding a new field field called "Beleinfo type" with the valie 100 or 300?

Re: One or more loops have been detected in your database structure.

Luke_Killer_IT — Fri, 27 Aug 2021 08:11:08 GMT

" differentiated them by adding a new field named "Beleinfo Type" with a value of 100 or 300?"
and how to do it I am new in qlik and do not know all the functions yet?

Re: One or more loops have been detected in your database structure.

Vegar — Fri, 27 Aug 2021 08:17:51 GMT

Like this

BelegInfo
LOAD *,
100 as BelegInfoType
FROM V_BelegInfo100;

CONCATENATE (BelegInfo)
LOAD * ,
300 as BelegInfoType
FROM V_BelegIngo300;

Re: One or more loops have been detected in your database structure.

Vegar — Fri, 27 Aug 2021 08:24:24 GMT

Maybe this article by @chrislofthouse: Qlik Sense Data Modelling: Concatenate vs Link Tables in Qlik, can be a good read for you.

Re: One or more loops have been detected in your database structure.

Luke_Killer_IT — Fri, 27 Aug 2021 08:35:43 GMT

when I put the tables together it showed me this

and that is not true

.In tables 100 and 300 I use where:
V_beleg100 where V_beleg100.company=100
V_beleg300 where V_beleg300.company=300

Re: One or more loops have been detected in your database structure.

Luke_Killer_IT — Fri, 27 Aug 2021 08:51:52 GMT

the probllem is that the table with 100 has to have data only for the company 100 and the table with 300 has to have data from 300 the problem is that I can't connect them together because there are gaps like on the above screen

Re: One or more loops have been detected in your database structure.

Vegar — Fri, 27 Aug 2021 14:12:42 GMT

It is hard to understand your gaps without more info, but if you choose use the concatenation technique then you can probably share some of the dimensions between the data sets as well by renaming them.

Beleg:
LOAD
V_beleg100.company as company,
V_beleg100.wunchtermin as wunchtermin,
V_beleg100.versand as versand,
V_beleg100.menge as menge
etc...
FROM V_beleg100;

CONCATENATE (Beleg) LOAD
V_beleg300.company as company,
V_beleg300.wunchtermin as wunchtermin,
V_beleg300.versand as versand,
V_beleg300.menge as menge
etc...
FROM V_beleg300;

Re: One or more loops have been detected in your database structure.

Luke_Killer_IT — Tue, 31 Aug 2021 11:42:28 GMT

The problem is that I cannot connect these tables together and they need to access the calendar.

it's supposed to look like this but it creates a loop and doesn't display all the data

Re: One or more loops have been detected in your database structure.

Vegar — Tue, 31 Aug 2021 15:45:34 GMT

Have you considered the linked table approach in the blog post i linked to earlier.

Maybe it could be a way to go?

Re: One or more loops have been detected in your database structure.

Luke_Killer_IT — Wed, 01 Sep 2021 04:38:06 GMT

yes i tried this solution. the problem is that the table V_BelegPos300 is the same as the table V_BelegPos 100 have the same data but I did them on different tables

Re: One or more loops have been detected in your database structure.

Luke_Killer_IT — Wed, 01 Sep 2021 05:27:36 GMT

My table is to display the relationship between v_belegpos300 and V_BelegPos100 porblem is so important that these tables are identical in their structure and contain the same data only breaking one table into two others and adding where V_BelegPos.company = 100 etc. returns me the appropriate data, but they must be connected to the calendar, but there is no problem here, because they do not connect, the problem appears when I add the e_belegpos table that connects these 2 tables with each other and a loop appears, how can I solve it because they are very important connections

Re: One or more loops have been detected in your database structure.

Vegar — Wed, 01 Sep 2021 06:47:55 GMT

If it is not possible to concat the two tables on each other then I suggest look into the "Link Tables in Qlik" section of the blog post or consider having duplicate e_belegpos and auftag tables as well, but that sounds to me as an not so good solution.

Re: One or more loops have been detected in your database structure.

Luke_Killer_IT — Wed, 01 Sep 2021 08:40:19 GMT

@Vegar

Is it me or did I use linktable wrong?