topic Date format when cross table used in QlikView

Date format when cross table used

renjithpl — Wed, 25 Aug 2010 11:34:10 GMT

Hello,

i have used crosstable while loading data to qlikview.

Directory;

CrossTable

(Datecoded, Data)
LOAD *
FROM
[Assignment Tracker.xlsx]
(ooxml, embedded labels, table is Production)
;

but the field " Datecoded "showing in number format. i just want it in MM-DD-YYYY format.

Normally i use date(Datecoded, 'MM-DD-YYYY') as Datecoded],

but i dont know to use the same when cross table is used.

Please guide me.

Lot of thanks in advance.

Miguel_Angel_Baeyens — Wed, 25 Aug 2010 12:20:23 GMT

Hello,

I'm guessing but it may be

CROSSTABLE (Datecoded, Data) LOAD Date(Datecoded) AS Datecoded, Data FROM ...

Hope that helps

renjithpl — Thu, 26 Aug 2010 13:34:10 GMT

it doesnt work dude, 😞

Tue, 08 Feb 2011 09:25:16 GMT

You must evaluate your date:

Map_Extradata:

Directory;

CrossTable(YourDate, Data,3)

LOAD * FROM

[\\telesto\Base para QV\Balance & Cta. Resultados\Datos adicionales resultados.xlsx]

(ooxml, embedded labels, table is Plano);

LOAD

Fila,

Concepto,

Empresa,

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

Datos as Amount

Resident Map_Extrasata;

Drop Table Map_Extradata;