Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

vinod2086
Contributor II

Month column issue

Hi Team,

i have scenario, i have a month column present and it is displaying values like 1.2.3..etc but here instead of 1,2,3 i want to display 01,02,03..etc

Thanks in advance.

1 Solution

Accepted Solutions
shraddha_g
Honored Contributor III

Re: Month column issue

Try num(MonthField,'00')

11 Replies
arvind_patil
Valued Contributor II

Re: Month column issue

Hi Kumar,

Try below one:

Date(Month(MonthField),'MM') As MonthField

Thanks,

Arvind Patil

mdmukramali
Valued Contributor II

Re: Month column issue

Dear,

Try 

Num(month,'##') as month

Thanks,

Mukram

shraddha_g
Honored Contributor III

Re: Month column issue

Try num(MonthField,'00')

vinod2086
Contributor II

Re: Month column issue

Hi,

thanks for your reply,

still expected values are not coming.

mdmukramali
Valued Contributor II

Re: Month column issue

Hi Kumar,

post sample data Apps.

shraddha_g
Honored Contributor III

Re: Month column issue

What are the values it giving?

vinod2086
Contributor II

Re: Month column issue

now values are displaying 01,02 ..etc thanks, Sharaddha

shraddha_g
Honored Contributor III

Re: Month column issue

Great!

daniel_kusiak
Contributor II

Re: Month column issue

Hi, try date(makedate(date_field),'YY') as date_field