topic Re: need help in Extracting only month in QlikView

need help in Extracting only month

Mon, 28 Apr 2014 14:07:02 GMT

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 — Mon, 28 Apr 2014 14:08:35 GMT

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

alexandros17 — Mon, 28 Apr 2014 14:09:04 GMT

If your field name is myField then write

Month(myField) to extract the month

Please let me know

its_anandrjs — Mon, 28 Apr 2014 14:10:40 GMT

Write like

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

You can directly used the calculated dimension like

Month(YourMonthYearField)

aveeeeeee7en — Mon, 28 Apr 2014 14:16:19 GMT

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

Tue, 29 Apr 2014 09:57:34 GMT

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

Month(YOUR_FIELD) as Month

Tue, 29 Apr 2014 10:00:56 GMT

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

regards,

Tue, 29 Apr 2014 10:46:40 GMT

thank you everyone .

ill try every option mentioned

MK_QSL — Tue, 29 Apr 2014 10:47:49 GMT

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

its_anandrjs — Tue, 29 Apr 2014 11:16:57 GMT

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

Regards