topic mmm-yyy to year in QlikView

mmm-yyy to year

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

My excel have a date format mmm-yyy but in qlikview i want to make a list box of year n month. is it possible?

sunny_talwar — Thu, 19 Jul 2018 16:23:02 GMT

May be this

Month(Date) as Month,

Year(Date) as Year

Month(Date#(Date, 'MMM-YYYY')) as Month

Year(Date#(Date, 'MMM-YYYY')) as Year

PabloTrevisan — Thu, 19 Jul 2018 16:42:29 GMT

You have to check if qlik is reading this excel data as DATE or STRING, try to use the date function with the mask you have this way:

Month (Date (datefield, 'MMM-YYY')) AS MONTH,

Year (Date (datefield, 'MMM-YYY)) AS YEAR'

DATE (datefield, 'MMM') AS MONTH,

DATE (datefield, 'YYY') AS YEAR

iliaisyah — Fri, 20 Jul 2018 07:12:25 GMT

Thank you. i now know to set the date period

PabloTrevisan — Fri, 20 Jul 2018 12:16:11 GMT

Please ILI,

mark the correct answer to close de topic.

thanks