Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Ankit1988
Contributor III
Contributor III

Number to Text or String Convert

Hi,

Ankit1988_0-1687161030617.png

 

As per above Image Data is Look like . Against the each number I wants Month name like(January February …. December)

Labels (1)
1 Solution

Accepted Solutions
tresesco
MVP
MVP

Month(Date#(Month,'M'))  as Month  

This will give you short month names like, - 'Jan', 'Feb'... If you need full names, you can change the system variable MonthNames values in the script.

View solution in original post

1 Reply
tresesco
MVP
MVP

Month(Date#(Month,'M'))  as Month  

This will give you short month names like, - 'Jan', 'Feb'... If you need full names, you can change the system variable MonthNames values in the script.