topic Re: to get month name and year from month in QlikView

to get month name and year from month

Wed, 25 Nov 2020 16:16:04 GMT

in dimension i have month field, but in the source as month as i have the format as 1/1/2016

but in the chart i want the axis to show as Jan 16

how do we do ? please help

CELAMBARASAN — Thu, 02 Mar 2017 09:13:51 GMT

Use MonthName(FieldName) in Dimension.

Or you can create this as new field in script to get used in multiple charts.

sarvesh — Thu, 02 Mar 2017 09:17:34 GMT

Hi.. Sona,

Use this code:

Date(Date#(yourdatefield,'DD/MM/YYYY'),'MMM YY') as yourdatefield

and make sure your MonthNames variable is set correctly to interpret the month names

Miguel_Angel_Baeyens — Thu, 02 Mar 2017 09:18:40 GMT

Or even easier, if this works for you, use

MonthName(DateField) AS MonthName

In your script rather than MonthName() in the expression, although it will work as well.

ramasaisaksoft — Thu, 02 Mar 2017 09:20:00 GMT

=Date(today(),'MMMYY')

=Date(FieldName,'MMMYY')

it will gives you Mar17

If you feel your issue is solved please close the thread by clicking "Correct Answer"

sarvesh — Thu, 02 Mar 2017 10:08:26 GMT

Please close the thread, if your problem has been resolved.