topic Re: How can I separate a Year/Month field into two fields in script in QlikView

How can I separate a Year/Month field into two fields in script

cliff_clayman — Wed, 25 Nov 2020 16:16:04 GMT

I have a field named [Year/month] and the values look like this: 2018/01 I need to pull out the Year value and the Month value as a name. I want to do this in the script. How can I do this?

Re: How can I separate a Year/Month field into two fields in script

MK_QSL — Wed, 21 Mar 2018 18:20:44 GMT

Date#([Year/month],'YYYY/MM') as [Year/month],

Year(Date#([Year/month],'YYYY/MM')) as Year,

Month(Date#([Year/month],'YYYY/MM')) as Month

Re: How can I separate a Year/Month field into two fields in script

ychaitanya — Wed, 21 Mar 2018 18:21:27 GMT

use the subfield function in the expr where ever you would like to

subfield([Year/month],'/',1) for field Year and subfield([Year/month],'/',2) for Month

Re: How can I separate a Year/Month field into two fields in script

wdchristensen — Wed, 21 Mar 2018 18:39:19 GMT

Left([Year/month], 4) AS MyYear, Right([Year/month], 2) AS MyMonth

Re: How can I separate a Year/Month field into two fields in script

cliff_clayman — Wed, 21 Mar 2018 18:41:08 GMT

I need the MyMonth to be Month name and not Month num.

Re: How can I separate a Year/Month field into two fields in script

ychaitanya — Wed, 21 Mar 2018 18:52:46 GMT

use inline load as

Mnth_Map:

Mapping Load * INLINE

[ Mnth_Num,Mnth_Name

1, Jan

2,Feb

3,Mar

]

then use

ApplyMap('Mnth_Map',subfield([Year/month],'/',2) ) as Month_Name,

subfield([Year/month],'/',1) as Year

Re: How can I separate a Year/Month field into two fields in script

MK_QSL — Wed, 21 Mar 2018 19:13:44 GMT

Have you tried as per my answer?

You will get something like below.

Re: How can I separate a Year/Month field into two fields in script

wdchristensen — Wed, 21 Mar 2018 19:24:11 GMT

Month(MakeDate(2018,Right([Year/month], 2))) as MyMonthName

Re: How can I separate a Year/Month field into two fields in script

cliff_clayman — Wed, 21 Mar 2018 19:41:35 GMT

I need the full moth name.

Re: How can I separate a Year/Month field into two fields in script

MK_QSL — Wed, 21 Mar 2018 20:04:51 GMT

Data:

Load

Date#([Year/month],'YYYY/MM') as [Year/month],

Year(Date#([Year/month],'YYYY/MM')) as Year,

Date(Date#(Month(Date#([Year/month],'YYYY/MM')),'MMM'),'MMMM') as Month

Inline

[

Year/month

2018/01

2018/02

2018/03

];

Re: How can I separate a Year/Month field into two fields in script

sasiparupudi1 — Thu, 22 Mar 2018 11:23:05 GMT

Long Month

Date(Date#(SubField('2017/12','/',2),'MM'),'MMMM')

Year

SubField('2017/12','/',1)