topic Reload Cross Table from Excel in QlikView

Reload Cross Table from Excel

christian77 — Mon, 31 Jan 2011 16:37:16 GMT

Hi people:

I need to reload a cross table from Excel. Since in the report to make, expressions are in columns and rows, my intention is having expressions loaded as fields and work with that.

My problem: I can´t load the table crossed as QV provides cause I don´t know how to use it properly.

Can somebody help me? Here is it. Script screen, plane files... In the middle of the process appears 'cross table'.

Thanks in advance.

Reload Cross Table from Excel

kuba_michalik — Mon, 31 Jan 2011 16:58:24 GMT

It's hard to say about what you should do without knowing the data you are trying to load. Could you perhaps tell us what columns are there in the Excel file?

Reload Cross Table from Excel

christian77 — Mon, 31 Jan 2011 17:45:47 GMT

Hi again:

Expresiones:

CrossTable([MES ACTUAL], Datos) // The field MES ACTUAL was not quoted or between brackeets

LOAD [PARAMETROS ESTADISTICOS],

[MES ACTUAL],

[MES AÑO ANTERIOR],

[DESVIACION %],

[ACUMULADO AÑO ACTUAL],

[ACUMULADO AÑO ANTERIOR],

[DESVIACION %1],

INTERANUAL,

OBJETIVO

FROM

[Expresiones.xls]

(biff, embedded labels, header is 2 lines, table is Enero$, filters(

Remove(Row, Pos(Top, 2))

));