topic Re: Cross table Load date field error in QlikView

Cross table Load date field error

ashok1203 — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have a Excel file, In that file the date field is in cross tabular format. I need to load the data in to Qlikview. While loading the data, For the date fields i am getting a values like 42339, 42421,.... like that. I tried to convert the values by using the Date and Date# functions. But, I am not getting the desired result. Can you please help me on this.

Re: Cross table Load date field error

varshavig12 — Fri, 06 Jan 2017 09:43:49 GMT

Output:

Re: Cross table Load date field error

MK_QSL — Fri, 06 Jan 2017 09:53:57 GMT

Check this link also.

Re: Crosstable numeric values

Temp:

CrossTable(Date,Value)

LOAD Style,

[42339],

[42370],

[42401],

[42430],

[42461],

[42491],

[42522],

[42552],

[42583],

[42614],

[42644],

[42675],

[42705],

[42736],

[42767],

[42795],

[42826],

[42856],

[42887]

FROM

[Test.xlsx]

(ooxml, embedded labels, table is Test);

NoConcatenate

Final:

Load Style, Date(Num#(Date)) as Date, Value Resident Temp;

Drop Table Temp;