topic Textobject won't hold more than 6 GetFieldSelections in QlikView

Textobject won't hold more than 6 GetFieldSelections

Thu, 20 Feb 2014 21:09:50 GMT

Greetings,

I have a list box which uses the windows checkbox style. As the user selects items, I want them to show in a text object. This works fine with =GetFieldSelections([acct number], ',') in the text formula box as long as the selections do not exceed six [acct number]. Any more selected and the text object displays "7 of 2145". Is there any way to display all of the GetFieldSelections in the text object?

Thanks,

Frank

Re: Textobject won't hold more than 6 GetFieldSelections

Nicole-Smith — Thu, 20 Feb 2014 21:11:31 GMT

If you want it to show more than 6, you need to up the max value:

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 )

So in your case (1000 or whatever number you want):

=GetFieldSelections([acct number], ',', 1000)

Re: Textobject won't hold more than 6 GetFieldSelections

Thu, 20 Feb 2014 21:16:43 GMT

Thank you!