need help in Extracting only month

[#1]

Iam new to qlikview and trying to Create Dash bord with Same Excel data.

i have column called Month-Year having data like (Jan 2013) i want to bring only Month Name and want to use that in X-axis .

I mean it as to show Only month Names on X-axis.

[MK_QSL]

Month(Date#(YourFieldName,'MMM YYYY')) as Month

[alexandros17]

If your field name is myField then write

Month(myField) to extract the month

Please let me know

[its_anandrjs]

Write like

Month(Date(Date#(YourMonthYearField,'MMM YYYY'),'MMM')) as Month

Or

You can directly used the calculated dimension like

Month(YourMonthYearField)

[aveeeeeee7en]

Hi Hareesh

If you have field MonthName eg. Jan 2012, Feb 2014, Mar 2013, etc
than you can use following options in your chart:

1) SubField(MonthName,' ',1)

2) Left((MonthName),3)

or use it in your script:

SubField(MonthName,' ',1)  AS Month

Regards

Aviral

[#6]

Month(Date#(YOUR_FIELD,'MMM YYYY')) as Month

OR

Month(YOUR_FIELD) as Month

[#7]

try Left(YourField, 3) this will show you the first 3 letters of your field.

regards,

MT

[#8]

thank you everyone .

ill try every option mentioned

[MK_QSL]

Try it and once your get your requirements fulfilled, close the thread by selecting appropriate answer.

[its_anandrjs]

If you got correct answer from the thread so mark the thread as correct / helpful for the references

Regards