topic Re: Least 3 values in list box in QlikView https://community.qlik.com/t5/QlikView/Least-3-values-in-list-box/m-p/554046#M207002 <HTML><HEAD></HEAD><BODY><P>If you meant "I need to display at least 1 value" you can try:</P><P></P><P>=FieldValue( 'YourField', n)</P><P></P><P>otherwise if you meant "I need to display the last value" you can try:</P><P>=FieldValue('YourField',FieldValueCount('YourField'))</P><P></P><P></P><P>From QlikView Help: </P><P><STRONG><BR /></STRONG></P><P><STRONG>Fieldvalue(<EM>fieldname , n</EM>) </STRONG></P><P></P><P>Returns the field value found in position n of the field <EM>fieldname</EM> (by load order). <EM>Fieldname</EM> 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. </P><P></P><P></P><P><STRONG>Fieldvaluecount(<EM>fieldname</EM> ) </STRONG></P><P></P><P>Returns the number of distinct values in a field. <EM>Fieldname</EM> must be given as a string (e.g. a quoted literal). </P></BODY></HTML> Fri, 30 Aug 2013 16:06:45 GMT Andrea_Ghirardello 2013-08-30T16:06:45Z Least 3 values in list box https://community.qlik.com/t5/QlikView/Least-3-values-in-list-box/m-p/554044#M207000 <HTML><HEAD></HEAD><BODY><P>i have the requirement is displays least 1 value</P></BODY></HTML> Fri, 30 Aug 2013 13:58:13 GMT https://community.qlik.com/t5/QlikView/Least-3-values-in-list-box/m-p/554044#M207000 2013-08-30T13:58:13Z Re: Least 3 values in list box https://community.qlik.com/t5/QlikView/Least-3-values-in-list-box/m-p/554045#M207001 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Please explain in more then only we can understand and try to fix it.</P></BODY></HTML> Fri, 30 Aug 2013 14:01:51 GMT https://community.qlik.com/t5/QlikView/Least-3-values-in-list-box/m-p/554045#M207001 v_iyyappan 2013-08-30T14:01:51Z Re: Least 3 values in list box https://community.qlik.com/t5/QlikView/Least-3-values-in-list-box/m-p/554046#M207002 <HTML><HEAD></HEAD><BODY><P>If you meant "I need to display at least 1 value" you can try:</P><P></P><P>=FieldValue( 'YourField', n)</P><P></P><P>otherwise if you meant "I need to display the last value" you can try:</P><P>=FieldValue('YourField',FieldValueCount('YourField'))</P><P></P><P></P><P>From QlikView Help: </P><P><STRONG><BR /></STRONG></P><P><STRONG>Fieldvalue(<EM>fieldname , n</EM>) </STRONG></P><P></P><P>Returns the field value found in position n of the field <EM>fieldname</EM> (by load order). <EM>Fieldname</EM> 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. </P><P></P><P></P><P><STRONG>Fieldvaluecount(<EM>fieldname</EM> ) </STRONG></P><P></P><P>Returns the number of distinct values in a field. <EM>Fieldname</EM> must be given as a string (e.g. a quoted literal). </P></BODY></HTML> Fri, 30 Aug 2013 16:06:45 GMT https://community.qlik.com/t5/QlikView/Least-3-values-in-list-box/m-p/554046#M207002 Andrea_Ghirardello 2013-08-30T16:06:45Z