Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
byrnel0586
Creator
Creator

Month Number to Display as Name

I had to change my month names to numbers in order to use them as max values in some expressions. Now I am needing them to display as 'Jan', 'Feb', etc for the list box selection but still maintain a numeric value.

I have tried the Pick and Dual(Pick( functions, but they are not sorting properly even when I choose ascending by numeric value. Is there any way to preserve the numeric trait while displaying as text?

2 Replies
sunny_talwar

Try this

=Month(Date#(MonthNumberField, 'M'))

jmvilaplanap
Specialist
Specialist

Hi

You can use two expressions

  • Month(MonthNumericField)
  • date(MonthNumericField, 'MMM')

With this two expressions you will show the numeric fields as string fields