Date format when cross table used

[renjithpl]

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]

Hello,

I'm guessing but it may be

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

Hope that helps

[renjithpl]

it doesnt work dude, 😞

[#4]

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;