topic Re: How to convert the num into Date in QlikView

How to convert the num into Date

Mon, 26 Jan 2026 18:19:17 GMT

Hi All,

I have the following excel, which includes the YearMonth, but when I load the it into QV, it shows the Int format, could you help me on how to convert it into Date by

script?

I have attached the Excel file and QVW as attached, could you help me out?

Thanks.

Re: How to convert the num into Date

kaushiknsolanki — Mon, 22 Apr 2013 06:01:53 GMT

Try this.

TestTable:

CrossTable(YearMonth, Revenue)
LOAD Region,
     [40452],
     [40483],
     [40513],
     [40544]
FROM
Test.xlsx
(ooxml, embedded labels, table is Sheet1);

NoConcatenate
Load MonthName((num#(YearMonth))) as YearMonth1,Revenue,Region Resident TestTable;

drop table TestTable;

Regards,

Kaushik Solanki

Re: How to convert the num into Date

er_mohit — Mon, 22 Apr 2013 07:22:42 GMT

See the attached file

CrossTable( Date,Value)

LOAD Region,

[40452] ,

[40483],

[40513],

[40544]

FROM

(ooxml, embedded labels, table is Sheet1);

LOAD Region as REGION,Value AS VALUE, dATE(Num#(Date)) AS DATE

Resident A;

DROP Table A;