Table syncronization qlikview desktop

[#1]

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

[Miguel_Angel_Baeyens · Accepted solution]

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

[#3]

Thank you Miguel Angel for your quick response

Regards

Oronzo