Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am using =Getfieldselection(Field1) in a variable v1.
When i select more than 6 values in Field1 using listbox, then the variable in text object shows "NOT apple,mango".
instead of showing the selected values.
What can we do for this?
Hi,
see QV help file for details like:
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 )
Good luck!
Rainer
Hi,
see QV help file for details like:
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 )
Good luck!
Rainer
Hi,
The syntax for Getfieldselections() is
=Getfieldselections(DimensionName, value separator, Max values)
By default the max values is 6, if you specify more than that the values are displayed, if the values are more than the given number then qlikview automatically formats the result as "NOT apple,mango" if excluded values are less.
Hope this helps you.
Regards,
Jagan.
Hi,
please try this:
getfieldselections(Field1,',',getpossiblecount(Field1))
BR
Matthias
try this:
=getfieldselections(Fieldname,',',8)
8 is the number of fields, so you can adjust it urself
Thanks for the answer.
It's working fine