Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
vinod2086
Creator II
Creator 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
Partner - Master III
Partner - Master III

Try num(MonthField,'00')

View solution in original post

11 Replies
arvind_patil
Partner - Specialist III
Partner - Specialist III

Hi Kumar,

Try below one:

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

Thanks,

Arvind Patil

mdmukramali
Specialist III
Specialist III

Dear,

Try 

Num(month,'##') as month

Thanks,

Mukram

shraddha_g
Partner - Master III
Partner - Master III

Try num(MonthField,'00')

vinod2086
Creator II
Creator II
Author

Hi,

thanks for your reply,

still expected values are not coming.

mdmukramali
Specialist III
Specialist III

Hi Kumar,

post sample data Apps.

shraddha_g
Partner - Master III
Partner - Master III

What are the values it giving?

vinod2086
Creator II
Creator II
Author

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

shraddha_g
Partner - Master III
Partner - Master III

Great!

daniel_kusiak
Creator II
Creator II

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