topic Re: Month and Year from date in QlikView

Month and Year from date

amit_saini — Wed, 24 Jun 2015 13:00:23 GMT

Hi Folks,

Could u plz see the attachment and tell me why year and month values are not visible.

Thanks,

Anonymous — Wed, 24 Jun 2015 13:04:42 GMT

These fields Show null values in the datamodel

try year(date#(Date,'MMM DD,YYYY'))

sunny_talwar — Wed, 24 Jun 2015 13:05:54 GMT

Try this script:

LOAD *,

month(Date) as Month,

year(Date) as Year;

LOAD Date#(Date, 'MMM DD, YYYY') as Date,

Name,

Revision

FROM

[2015-01-31-ecoReport.xlsx]

(ooxml, embedded labels, table is RawData);

alexandros17 — Wed, 24 Jun 2015 13:08:42 GMT

this is the correct syntax for load:

LOAD Date,
month(Date#(Date, 'MMM DD, YYYY')) as Month,
year(Date#(Date, 'MMM DD, YYYY')) as Year,
Name,
Revision
FROM
....

buzzy996 — Wed, 24 Jun 2015 13:25:34 GMT

PFA,