Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
shamitshah
Partner - Creator
Partner - Creator

Format date in a chart

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

1 Solution

Accepted Solutions
Anil_Babu_Samineni

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

3 Replies
Anil_Babu_Samineni

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
Not applicable

Try this

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

shamitshah
Partner - Creator
Partner - Creator
Author

Thanks Anil,

I changed it to

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

Worked out perfectly.