Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Not applicable

need help in Extracting only month

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.

9 Replies
MVP
MVP

Re: need help in Extracting only month

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

Re: need help in Extracting only month

If your field name is myField then write

Month(myField) to extract the month

Please let me know

Re: need help in Extracting only month

Write like

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

Or

You can directly used the calculated dimension like

Month(YourMonthYearField)

aveeeeeee7en
Valued Contributor III

Re: need help in Extracting only month

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

Not applicable

Re: need help in Extracting only month

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


OR


Month(YOUR_FIELD) as Month

Not applicable

Re: need help in Extracting only month

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

regards,

MT

Not applicable

Re: need help in Extracting only month

thank you everyone .

ill try every option mentioned

MVP
MVP

Re: need help in Extracting only month

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

Re: need help in Extracting only month

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

Regards