Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
Hi Alessandro,
but i need the Date field relationed in the tables
i mean, i have a calendar with Date because i need Date be the period field
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