How to convert month from numbers to text in the bar chart dimension

[#1]

Hi,

I am very new to Qlik view, I need to  show month as the dimensions.

Can some one help me how to convert Month values in my table from 1,2,3....12 to Jan, Feb, Mar....Dec using various options like by if statement, set analysis....

[vinieme12]

create a mapping table  to  map month numbers to monthnames during load and then use this field in your charts

Map_Month:

Mapping Load * INLINE [

MonthNumber,MonthName

1,Jan

2,Feb

.

.

.

];

FACT:

LOAD * ,

Applymap('Map_Month',yourmonthfieldinFACT) as MonthShortName

FROM...

[sunny_talwar]

Another way to do this would be to do like this:

as your dimension

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

or this in load script

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

and then just use MonthName as your dim

[Anil_Babu_Samineni]

You want to show only one object for this

You may try this too

Take List box and choose Expression from Drop down then paste this and change your field name instead of MonthFieldName then give Title Month

Pick(Match(MonthFieldName, '1','2','3','4','5','6','7','8','9','10','11','12'),'Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec')

[varshavig12]

Date(Date#(Month,'MM'),'MMM')

or

Month(Date#(Month,'MM'))

[Anonymous]

Hi,

In any Expressions or In Dimensions,

If you write Month(Your date filed),it will brings months name like...jan,feb,,....dec.

and

if you write num(Month(your date filed)),it will brings months numbers like..1,2,3,...12.

[Anonymous]

If you want to convert months from numbers(1,2,3........12)to names(jan,feb,.....dec),

Month(Date#(your date filed,'M'))

[#8]

By using Month function we can derive month from Date field like below

Month(Date)

Month (Today()))

[#9]

Thanks to all of you for your valuable answers. I posted a new question.

Can some one help me with that