Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
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 )

View solution in original post