topic Table syncronization qlikview desktop in QlikView

Table syncronization qlikview desktop

Mon, 29 Aug 2011 10:11:00 GMT

Hello,

I have loaded into a script data from excel file into a TABLE called Invt and I have tried to load data into table called Saldi

My problem is that when I select a row in the first table I don't see the same selection in the second table.

.....

Invt:

LOAD Banca,

ABI,

Tipo,

Causale,

[Nostro Riferimento],

[Vostro Riferimento],

[Numero Movimento],

Dossier,

Controparte,

[Descrizione Ctp],

divisa,

divisa1,

Nominale, ....

FROM

(biff, embedded labels, header is 1 lines, table is [Inventario$]);

Saldi:

Load [Trade Date] as dts ,Nozionale as qt, Controvalore as cv Resident Invt;

What should I correct the script to have synchronized the two tables?

Thank

Table syncronization qlikview desktop

Miguel_Angel_Baeyens — Mon, 29 Aug 2011 10:13:57 GMT

Hi,

QlikView associates (joins) tables when at least one of the field names in both tables are the same. Then, selections in one table be reflected in the second table, and viceversa.

However, I don't know your model, and I don't know which field in table Invt should be named alike in table Saldi in order to get the expected results.

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

Table syncronization qlikview desktop

Mon, 29 Aug 2011 10:39:51 GMT

Thank you Miguel Angel for your quick response

Regards

Oronzo