topic Re: Convert text month MMM into MM in QlikView

Convert text month MMM into MM

saumyashah90 — Mon, 02 Nov 2015 03:10:44 GMT

i have a month which are text

Jan

Feb

Mar

Oct

Need to convert in to months MM in date format

Re: Convert text month MMM into MM

sunny_talwar — Mon, 02 Nov 2015 03:13:38 GMT

Try this in the script:

Month(Date#(MonthField, 'MMM')) as MonthField

Where Month is dual and will be both Text and Number.

Re: Convert text month MMM into MM

saumyashah90 — Mon, 02 Nov 2015 03:16:31 GMT

i want in MM not in MMM

which is not happening...

Re: Convert text month MMM into MM

sunny_talwar — Mon, 02 Nov 2015 03:20:22 GMT

Try this:

Num(Month(Date#(MonthField, 'MMM'))) as MonthField

Re: Convert text month MMM into MM

sunny_talwar — Mon, 02 Nov 2015 03:22:10 GMT

You can also try this:

Match(MonthField, 'Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun', 'Jul', 'Aug', 'Sep', 'Oct', 'Nov', 'Dec') as MonthField

Re: Convert text month MMM into MM

Anonymous — Mon, 02 Nov 2015 04:06:42 GMT

you have month column separately I will suggest use Mapping load

and then use ApplyMap() function to replace Jan with 01,

Thanks

BKC

Re: Convert text month MMM into MM

jagan — Mon, 02 Nov 2015 04:10:34 GMT

Hi Saumya,

Try like this

LOAd

Date(Date#(MonthField, 'MMM'), 'MM') as MonthField

FROM DataSource;

LOAd

Match(MonthField, 'Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun', 'Jul', 'Aug', 'Sep', 'Oct', 'Nov', 'Dec') as MonthField

FROM DataSource;

by using Mapping table.

Hope this helps you.

Regards,

Jagan.

Re: Convert text month MMM into MM

Anonymous — Mon, 02 Nov 2015 06:46:06 GMT

Try Some thing like this,

Month(Date(Date#(Field name,'MMM'),'MM')) as Temp

Re: Convert text month MMM into MM

JohanLind1979 — Tue, 17 Mar 2020 13:00:42 GMT

I just had the same problem. num(MonthField,'00') solves the problem within QlikView/Qlik Sense but the problem is that when I export to excel, the entry in the cell is '0' even though it displays '00'. I added the Text() function and that worked. Now it is ok in Qlik Sense and also after excel export. Final syntax is text(num(MonthField,'00'))