Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Least 3 values in list box

i have the requirement is displays least 1 value

2 Replies
v_iyyappan
Specialist
Specialist

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).