topic Loosely Coupled in QlikView

Loosely Coupled

olramirez — Tue, 21 Oct 2014 21:52:39 GMT

Hello,

Could you help me with this topic?

I have three tables P&L, Cartera, Customer like picture

I did a Concatenate in Qlikview with P&L and Cartera, but when i execute it say to me: Circular Reference, something Loosely Coupled.

How can i do the relationship between this three tables in Qlikview?

afurtado — Tue, 21 Oct 2014 22:06:26 GMT

Hi Olga.

The problem is that you have the same field name (Date) in P&L and Cartera.

Rename Date in Cartera and it should work.

Best,

Alessandro Furtado

olramirez — Tue, 21 Oct 2014 22:10:33 GMT

Hi Alessandro,

but i need the Date field relationed in the tables

olramirez — Tue, 21 Oct 2014 22:28:48 GMT

i mean, i have a calendar with Date because i need Date be the period field

afurtado — Tue, 21 Oct 2014 22:53:08 GMT

Is better when we see data, but if you have Date in Cartera and same Date in P&L maybe work.

like this:

LOAD * FROM Customer

left join

LOAD * FROM Cartera

left join

LOAD * FROM P&L

Best,

Alessandro Furtado