Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Talk to Experts, a LIVE Q&A Webinar. Bring your Qlik Sense Business questions on Aug. 4th. Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Partner
Partner

Try num(MonthField,'00')

View solution in original post

11 Replies
Highlighted
Partner
Partner

Hi Kumar,

Try below one:

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

Thanks,

Arvind Patil

Highlighted
Specialist III
Specialist III

Dear,

Try 

Num(month,'##') as month

Thanks,

Mukram

Highlighted
Partner
Partner

Try num(MonthField,'00')

View solution in original post

Highlighted
Creator II
Creator II

Hi,

thanks for your reply,

still expected values are not coming.

Highlighted
Specialist III
Specialist III

Hi Kumar,

post sample data Apps.

Highlighted
Partner
Partner

What are the values it giving?

Highlighted
Creator II
Creator II

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

Highlighted
Partner
Partner

Great!

Highlighted
Creator II
Creator II

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