topic Re: Format date in a chart in QlikView

Format date in a chart

shamitshah — Wed, 25 Nov 2020 16:16:04 GMT

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 — Mon, 24 Jul 2017 03:47:57 GMT

Try this?

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

Mon, 24 Jul 2017 03:50:20 GMT

Try this

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

shamitshah — Mon, 24 Jul 2017 03:51:40 GMT

Thanks Anil,

I changed it to

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

Worked out perfectly.