Least 3 values in list box

[#1]

i have the requirement is displays least 1 value

[v_iyyappan]

Hi,

Please explain in more then only we can understand and try to fix it.

[Andrea_Ghirardello]

If you meant "I need to display at least 1 value" you can try:

=FieldValue( 'YourField', n)

otherwise if you meant "I need to display the last value" you can try:

=FieldValue('YourField',FieldValueCount('YourField'))

From QlikView Help:

Fieldvalue(fieldname , n)

Returns the field value found in position n of the field fieldname (by load order). Fieldname must be given as a string value, e.g. the field name must be enclosed by single quotes. The first field value is returned for n=1. If n is larger than the number of field values, NULL is returned.

Fieldvaluecount(fieldname )

Returns the number of distinct values in a field. Fieldname must be given as a string (e.g. a quoted literal).