Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Convert months (numeric) into text

Hi Experts

I have a file that contains months in a numeric format. How can I convert the numeric values into text for the months? (Jan, Feb, e.g.)

Thank you for your help!

Jan

11 Replies
hariprasadqv
Creator III
Creator III

Hi,

use dual function or MMM format with date.

hic
Employee
Employee

If you want your month names automatically sorted - i.e. as dual values - you should use the solution suggested by Robert_Mika:

     Month(MakeDate(2015,MonthNumber))

Month names created with Text() will be sorted alphabetically, which you don't want.

An inline table will work, but this demands an additional table, when you really want to convert month numbers to month names when loading another table, i.e. inside another Load statement.

HIC