topic Re: month and week from date in QlikView

month and week from date

kunkumnaveen — Wed, 05 Oct 2016 06:02:10 GMT

HI,

How to get a Long Month Name (January,February .....) and week (Week1,Week2.......) from a date field

suppose my i got data like

Thanks...

Re: month and week from date

kunkumnaveen — Wed, 05 Oct 2016 06:08:24 GMT

i Tried this :

q1:

LOAD date#(Date,'DD/MM/YYYY') as Date,

quantity

FROM

(ooxml, embedded labels, table is Sheet1);

LOAD *,

month(date(Date,'MMMM')) as month,

//Month(Date#(Date,'DD/MMMM/YYYY')) as month,

//Month(Date(date#(Date,'DD/MM/YYYY'),'DD/MMMM/YYYY')) as month,

'Week'&Week(Date) as week

Resident q1;

DROP Table q1;

i couldn't get able to get Long Month Name

Re: month and week from date

tamilarasu — Wed, 05 Oct 2016 06:23:55 GMT

Hi Naveen,

Try,

q1:

Load *,

Date(Date,'MMMM') as Month,

'Week'&Week(Date) as Week;

LOAD Date#( Date,'DD/MM/YYYY') as Date,

quantity

FROM

(ooxml, embedded labels, table is Sheet1);

Re: month and week from date

kunkumnaveen — Wed, 05 Oct 2016 06:44:56 GMT

HI Nagaraj,

i tried ur code and i am getting this

i just want only one of each value .....

Re: month and week from date

tamilarasu — Wed, 05 Oct 2016 06:59:39 GMT

Naveen,

Try this,

Load*,

Dual(Date(Date,'MMMM') ,Month(Date)) as Month,

'Week' & Week(Date) as Week;

LOAD Date#( Date,'DD/MM/YYYY') as Date,

quantity

FROM

(ooxml, embedded labels, table is Sheet1);

Note: Updated the second parameter in the dual function.

Re: month and week from date

kunkumnaveen — Wed, 05 Oct 2016 07:02:33 GMT

It worked ...thanks

what really dual is doing over here

Dual(Date(Date,'MMMM') ,Month(Date(Date,'MMM'))) as Month,

Re: month and week from date

tamilarasu — Wed, 05 Oct 2016 07:05:59 GMT

Great. Below link might be helpful to understand the dual function better.

How to use- Dual()