topic Month Year format in QlikView

Month Year format

bilionut — Wed, 09 May 2012 07:48:06 GMT

Hi,

To display in order Month and Year I use this expresion:

dual( Month(MyDate) & '-' & Year(MyDate), num(Year(MyDate)) & num(Month(MyDate), '00' )) as MonthYear,

and the result is something like MMM-YYYY.

How should I change the expression or what else should I do to change the format display in something like that MMM-YY ?

Thanks for help,

Ionut

Miguel_Angel_Baeyens — Wed, 09 May 2012 07:54:57 GMT

Hi Ionut,

Try this instead:

Dual(Month(MyDate) & '-' & Date(MyDate, 'YY'), Num(Year(MyDate)) & Num(Month(MyDate), '00')) AS MonthYear,

Note the Date(MyDate, 'YY') in the expression above.

Hope that helps.

Miguel

its_anandrjs — Wed, 09 May 2012 08:02:15 GMT

Hi,

Create date field some thing like this

dual( Month(MyDate) & '-' & Year(date(MyDate,'DD.MM.YY')), num(Year(MyDate)) & num(Month(MyDate), '00' )) as MonthYear,

Regards,

Anand

bilionut — Wed, 09 May 2012 08:13:33 GMT

It work!

Thanks a lot

Ionut