Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
use Expression in the list box
and in expression tab use
= maxstring (Report Month)
Hope it helps
Sri1
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'))
Hi,
Try,
MonthName(max(YourField))
Regards