Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i have the requirement is displays least 1 value
Hi,
Please explain in more then only we can understand and try to fix it.
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).