Loosely Coupled

[olramirez]

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]

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]

Hi Alessandro,

but i need the Date field relationed  in the tables

[olramirez]

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

[afurtado]

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