topic First value of a field in QlikView https://community.qlik.com/t5/QlikView/First-value-of-a-field/m-p/1368781#M418569 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>How do I extract the first value of a field according to load order?</P><P></P><P>Thanks</P></BODY></HTML> Thu, 18 May 2017 15:58:40 GMT 2017-05-18T15:58:40Z First value of a field https://community.qlik.com/t5/QlikView/First-value-of-a-field/m-p/1368781#M418569 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>How do I extract the first value of a field according to load order?</P><P></P><P>Thanks</P></BODY></HTML> Thu, 18 May 2017 15:58:40 GMT https://community.qlik.com/t5/QlikView/First-value-of-a-field/m-p/1368781#M418569 2017-05-18T15:58:40Z Re: First value of a field https://community.qlik.com/t5/QlikView/First-value-of-a-field/m-p/1368782#M418570 <HTML><HEAD></HEAD><BODY><P>Try this :</P><P>FieldValue()</P><P></P><P>Ref:</P><P class="syntax"><A name="kanchor311"></A><A name="Fieldvalue"></A><SPAN class="Bold">Fieldvalue(</SPAN><SPAN class="Italic">fieldname , n</SPAN><SPAN class="Bold">)</SPAN> </P><P>Returns the field value found in position <SPAN class="Italic">n</SPAN> of the field <SPAN class="Italic">fieldname</SPAN> (by load order). <SPAN class="Italic">Fieldname</SPAN> 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 <SPAN class="Italic">n</SPAN>=1. If <SPAN class="Italic">n</SPAN> is larger than the number of field values, NULL is returned. </P><P class="note">Note: This function will only work with distinct field values.</P><P class="example">Example:</P><P class="Code">fieldvalue( 'Helptext', 5 )</P></BODY></HTML> Thu, 18 May 2017 16:04:29 GMT https://community.qlik.com/t5/QlikView/First-value-of-a-field/m-p/1368782#M418570 vishsaggi 2017-05-18T16:04:29Z