How to show Most Latest Month in List box ?

[#1]

Hi Friends,

I am new to qlikview.

I have below issue.

I have data for all the month including most latest month in the qvd.

I have field - Report Month which contains below value.

Example -

Report Month

Jan-2014

Feb-2014

Mar-2014

Apr-2014

Apr-2014 is the most latest month in the values of Report Month.

I wnat to show only Apr-2014 in the List box.

how can we show that ?

Thanks!

[Anonymous]

use Expression in the list box

and in expression tab use

= maxstring (Report Month)

Hope it helps

Sri1

[MK_QSL]

Define your Month field as below in your script...

Load

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

Inline

[

Month

Jan-2014

Feb-2014

Mar-2014

Apr-2014

];

Now use below expression in your list box

=IF(Month = Date(Max(TOTAL Month),'MMM-YYYY'), Month)

====================

UPDATE:

Or directly use below expression in your list box...

=IF(Month = Date(Max(TOTAL Date#(Month,'MMM-YYYY')),'MMM-YYYY'), Date#(Month,'MMM-YYYY'))

[PrashantSangle]

Hi,

Try,

MonthName(max(YourField))

Regards