Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Check this link also.
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;
Output:
Check this link also.
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;