Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

bilionut
New Contributor III

Month Year format

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

Tags (2)
1 Solution

Accepted Solutions

Re: Month Year format

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

3 Replies

Re: Month Year format

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

Month Year format

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
New Contributor III

Month Year format

It work!

Thanks a lot

Ionut

Community Browser