Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
mahitham
Contributor

MonthYear help

Hi Experts,

Can any one please help me to convert the below Monthyear field from Text format to actual Motnhyear in Backend.

in the List box MonthYear is at left side because its in Text format and Max(MonthYear) is also not working.

Please help me on this.

Monthyear.png

1 Solution

Accepted Solutions
Luminary
Luminary

Re: MonthYear help

Try like this:

DATE(DATE#(DateField, 'MMM YYYY'), 'MM.YYYY') AS DateField

View solution in original post

1 Reply
Luminary
Luminary

Re: MonthYear help

Try like this:

DATE(DATE#(DateField, 'MMM YYYY'), 'MM.YYYY') AS DateField

View solution in original post