topic Re: Month in QlikView

Month

upaliwije — Tue, 12 May 2015 22:36:08 GMT

In my data table I have following field

Month_Year

JAN_2014

FEB_2014

.......

In my load load script I want to load two separate fields Month and Year

Pls help me to write script

Re: Month

rwunderlich — Tue, 12 May 2015 22:44:40 GMT

year(date#(Month_Year,'MMM_YYYY')) as Year

month(date#(Month_Year,'MMM_YYYY')) as Month

-Rob

Re: Month

upaliwije — Tue, 12 May 2015 22:53:39 GMT

Thanks it is working. I forgot to tell you I want extract month number like 1,2,3

Re: Month

rwunderlich — Wed, 13 May 2015 00:31:21 GMT

Month returns a dual, which is both a number and a string. The string will be used for display and the number used automatically for sorting and arithmetic.

you can explicitly extract the number of the month by adding a num() function.

num(month(date#(Month_Year,'MMM_YYYY'))) as Month

-Rob

http://masterssummit.com

http://robwunderlich.com