topic List Box in QlikView

List Box

brindlogcool — Sat, 14 Jan 2012 16:28:04 GMT

Hi,

I want to display the max year in the list box. I tried to use the create a variable with expression as Max(year) and used that variable in the list box it is displaying the Year correctly but not able to select the year from the list box. Also i have tried to use the max(year) in the list box but the same problem i am not able to do the selection.

It would be great if somebody helps me to fix this issue.

List Box

hic — Sat, 14 Jan 2012 21:21:09 GMT

A list box is always of list of all values in a field. However, if you create a statistics box, the maximum value of a field is one ov the things you can show. So, create a statisticts box and remove the other lines (Sum, Avg, Min, etc)

List Box

Sun, 15 Jan 2012 06:50:59 GMT

Hello,

For another option, you can also try to add the below script

MaxYear:

LOAD Max(Year) as Year, //linked here to MasterCalendar, to be linked to your desired data table
Max(Year) as MaxYear //this is the list box field that can be selected
Resident MasterCalendar; //or your data table where you create a Year field

Hope this helps too.