topic Re: Month Format in QlikView

Month Format

abhaysingh — Fri, 27 Mar 2015 10:14:29 GMT

Dear All,

i have month in

1,2,3,4,5,6,7,8,9,10 format

i want it in 01,02,03,04,05,06,07,08,09,10 format

how i can do this?

Anonymous — Fri, 27 Mar 2015 10:18:37 GMT

use num(month,'00')

MK_QSL — Fri, 27 Mar 2015 10:19:22 GMT

Date(Date#(Month,'M'),'MM') as Month

hariprasadqv — Fri, 27 Mar 2015 10:20:47 GMT

Linder is right, in a simple way.

anbu1984 — Fri, 27 Mar 2015 10:25:44 GMT

=Right('0'&Month,2)

Sat, 28 Mar 2015 10:10:04 GMT

Try this instead:

Dual(Month(MyDate) & '-' & Date(MyDate, 'YY'), Num(Year(MyDate)) & Num(Month(MyDate), '00')) AS Month Year,

Note the Date(MyDate, 'YY') in the expression above.

mukesh24 — Sat, 28 Mar 2015 10:26:06 GMT

Hi Abhay,

As suggested by Linder, simple way use num(month,00)

Sat, 28 Mar 2015 10:27:09 GMT

Hi,

You can try this,

IF(LEN(MONTH_field)=1,month(month#(MONTH_field,'M'),'MM'),if(LEN(MONTH_field)=2,month(month#(MONTH_field,'MM'),'MM')))

Sat, 28 Mar 2015 10:32:19 GMT

Hi try this expression also

Date((YourDateField,'MMM-YY') as YourDateField

Sat, 28 Mar 2015 10:40:28 GMT

Hi,

You can try this in script,

IF(LEN(MONTH_field)=1,month(month#(MONTH_field,'M'),'MM'),if(LEN(MONTH_field)=2,month(month#(MONTH_field,'MM'),'MM'))) as month