field value and field index explination pls?

Sun, 09 Feb 2014 15:34:15 GMT

thanks in advance

Re: field value and field index explination pls?

jagan — Sun, 09 Feb 2014 16:23:39 GMT

Hi Manoj,

FieldValue() and FieldIndex() are used to get the values or the index of a dimension. For example

Country

India

USA

Russia

Fieldindex( 'Country', 'USA' )

Will give you the value 2, because USA is in second position.

FieldValue('Country', 2)

Will give you the value USA, because second value in the Country dimension is USA.

From Qlikview help file:

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.

Example:

fieldvalue( 'Helptext', 5 )

FieldIndex(fieldname , value )

Returns the position of the field value value in the field fieldname (by load order). If value cannot be found among the field values of the field fieldname, 0 is returned. Fieldname must be given as a string value, e.g. the field name must be enclosed by single quotes.

Example:

fieldindex( 'Name', 'John Doe' )

Regards,

Jagan.

topic field value and field index explination pls? in QlikView

field value and field index explination pls?

Re: field value and field index explination pls?