Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

First value of a field

Hi,

How do I extract the first value of a field according to load order?

Thanks

1 Solution

Accepted Solutions
vishsaggi
Champion III
Champion III

Try this :

FieldValue()

Ref:

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.

Note: This function will only work with distinct field values.

Example:

fieldvalue( 'Helptext', 5 )

View solution in original post

1 Reply
vishsaggi
Champion III
Champion III

Try this :

FieldValue()

Ref:

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.

Note: This function will only work with distinct field values.

Example:

fieldvalue( 'Helptext', 5 )