topic Re: Load many tables in QlikView

Load many tables

Anonymous — Mon, 17 Dec 2012 22:04:15 GMT

Hi,

I have many tables.

I want to connect together.

I use QUALIFY *; UNQUALIFY respondentID;

Please see my picture. How can I connect tables ( pointed red and blue lines)

Thanks,

MayilVahanan — Mon, 17 Dec 2012 22:23:07 GMT

Rename the field and qv connect automatcially

ex:

Load Sales as TotalSales from Table1;

Load Total_Sales as TotalSales from Table2;

Qv connect both and display as one field

pljsoftware — Mon, 17 Dec 2012 23:24:47 GMT

Hi Vladimir,

you must to use

qualify *;

unqualify [fieldName1], [fieldName2], [fieldName3];

load

f1,

f2,

f3,

f4 as fieldName1

from ....;

unqualify *;

FieldName1,2,3 are your field ID as tagID and questionID.

Regards

Luca Jonathan Panetta