Cross table Load date field error

[ashok1203]

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.

[varshavig12]

Output:

[MK_QSL · Accepted solution]

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;