How to Convert Month name and year for the formatt... - Qlik Community

Report Inappropriate Content · ‎2012-05-21

Hi All,

I need to convert MMM-YY for ex "apr-12" formatt to get quartet and year.

Jason_Michaelides · ‎2012-05-21

You could try:

QuarterName(Date#(YourDateField,'mmm-YY')) AS QuarterYear

Hope this helps,

Jason

Report Inappropriate Content · ‎2012-05-21

Depending on your field datatype Date(FieldA,'MMM-YY')

SunilChauhan · ‎2012-05-21

ue below code in script

MonthName&'-'&Year as MonthYear

or

MonthName&'-'&Year in direct dimension

hope ths helps

Sunil Chauhan

How to Convert Month name and year for the formatt like this "Apr-12"