Displaying MMM-YY correctly when exported to Excel

SamWeatherby — Fri, 08 Jul 2022 11:17:00 GMT

I have a datetime field being displayed as 'MMM-YY' in a straight table chart. My service users are required to export this data into Excel (likely to create their own pivots from) but when doing so, this field is displayed alphabetically (Apr-22, Aug-22 etc.). I have tried the following two date functions in Qlikview which results in the same alphabetical display when exported to Excel:

1) =MontName([Field])

2) =Date([Field],'MMM-YY')

Is there an alternative function that would make Excel see this as a date whilst maintaining the 'MM-YYY' format?

Thanks

Sam

Re: Displaying MMM-YY correctly when exported to Excel

sergio0592 — Fri, 08 Jul 2022 13:46:46 GMT

Hi,

In Qlikview try with interpreting function :

=Date#(Field,'MMM-YY')

topic Displaying MMM-YY correctly when exported to Excel in QlikView

Displaying MMM-YY correctly when exported to Excel

Re: Displaying MMM-YY correctly when exported to Excel