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: 
Not applicable

Converting numbers to month name

Hi,

Can some one help me in converting the numbers to month names?

I want to remove this number and just want to have the month names.

or is there any possibility to just change these numbers to month names.

Initially i used if statement to bring the month names. But i dont know how to replace the numbers with month names. Thank you.

Capture.PNG

25 Replies
CELAMBARASAN
Partner - Champion
Partner - Champion

Try this

=Month(Date(Date#([SPEND MONTH], 'YYYYMM MMM')))

Assuming that your field value is '201402 Feb', you will get Feb here.

Peter_Cammaert
Partner - Champion III
Partner - Champion III

What are you showing in your screenshot example in the OP? Is it a listbox?

Peter_Cammaert
Partner - Champion III
Partner - Champion III

How about:

=right([SPEND MONTH], 3)

Anonymous
Not applicable
Author

Hi,

As your field contains data like "201401, 201402,..."

You can try in the script:

Table:

LOAD

     [SPEND MONTH],

     Month(Date#('01/'&right([SPEND MONTH],2)&'/'&left([SPEND MONTH],4),'DD/MM/YYYY')) as SpendMonth

FROM

File;

Then your field SpendMonth will contain the month name

anbu1984
Master III
Master III

Can you post sample app

Not applicable
Author

Hi Charen - probably a silly suggestion, so ignore if not applicable:  it almost sounds like you're looking for the right(datestring,2) (e.g. '201403' to yield 03), and then to applymap the numbers to a loaded mapping table, e.g. with 03,Mar or something to get the 'monthname' (?)