CrossTable and Date format

Thu, 03 Feb 2011 15:44:33 GMT

Hi peopple

I'm going crazy.

I have this crosstable:

I load without problems:

Datos_Extra:
Directory;
CrossTable(Fecha, Datos)
LOAD * FROM
[\\telesto\Base para QV\Balance & Cta. Resultados\Datos adicionales resultados.xlsx]
(ooxml, embedded labels, table is Plano);

But the date is interpreted as a number.

I tried to reformat, but no way.

Does anyone know how?

Datos_Extra2:
LOAD *,
date(Fecha) as "Posting Date"
Resident Datos_Extra;
DROP TABLE Datos_Extra;

Thanks

CrossTable and Date format

Thu, 03 Feb 2011 16:28:28 GMT

Ok don't worry.

I have the solution.

I don't know why, QV in a CrossTable format the number as a text.

We must fist, format a number and then date.

This is the solution:

topic CrossTable and Date format in QlikView

CrossTable and Date format

CrossTable and Date format

Date(Num(Evaluate(Fecha) )) as "Posting Date",