How to sort latest YEAR and MONTH in text and image chart

[nurulizzaty]

I wanted to sort latest YEAR and MONTH in my text and image chart. But I cannot find the syntax. 

Really need your help guys...

[zzyjordan]

Hi,
have you tried use MonthName(max(your Date field)) in your measure expression?
ZZ

[nurulizzaty]

I cannot use function MAX and i don't know why, it shows error...

[zzyjordan]

can you give some more information about the error, e.g. screenshot or your sample data?

ZZ

[nurulizzaty]

Above are the screenshots.....

[zzyjordan]

The expression should be like this

MonthName(max(INCIDENT_MONTH))

The bold part is the qlik sense function, and I assume your field [INCIDENT_MONTH] is a datetime type.

ZZ

[nurulizzaty]

but then, it shows this...

[zzyjordan]

can you attace the qvf ?
ZZ