topic Get the first field selected in QlikView

Get the first field selected

Thu, 14 Jan 2010 14:44:15 GMT

I 've a field with dates (e.g. ACCOUNT_DATE).
If I select many dates, how to write the first account_date selected in a text object?

Thanks in advance.

Get the first field selected

amars — Thu, 14 Jan 2010 14:57:01 GMT

getfieldselections ( FieldName [, ValueSep [, MaxValues]] )

Returns a string with the current selections in a field.

ValueSep is the separator to be put between field values. The default is ', '. Maxvalues is the maximum number of field values to be individually listed. When a larger number of values is selected the format 'x of y values' will be used instead. The default is 6.

Examples

getfieldselections ( Year )

getfieldselections ( Year, '; ' )

getfieldselections ( Year, '; ' , 10 )

See if this help's.

You can get all the selections for the field & then using string function like Mid & FindOneof to retrieve the first token.

Regards

Get the first field selected

Anonymous — Thu, 14 Jan 2010 14:57:32 GMT

maybe something like min(ACCOUNT_DATE) ... to retrieve the lowest/first??