Solved: Re: Format date in a chart - Qlik Community

shamitshah · ‎2017-07-23

Hi,

I have the following in the script

MonthName(Period) as Month

which results in MM-YYYY

I need the result to be the format e.g. Jan-17 instead of Jan 2017

Any idea how I can achieve the above?

Thanks

Anil_Babu_Samineni · ‎2017-07-23

Try this?

Date(MonthName(Period),'MMM-YYYY') as Month

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

View solution in original post

Anil_Babu_Samineni · ‎2017-07-23

Try this?

Date(MonthName(Period),'MMM-YYYY') as Month

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

Report Inappropriate Content · ‎2017-07-23

Try this

Date(MonthName(Period),'MMM-YY') as Month

shamitshah · ‎2017-07-23

Thanks Anil,

I changed it to

Date(MonthName(Period),'MMM-YY') as Month

Worked out perfectly.

Format date in a chart

QlikView App Dev