Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

NOT in listbox selections

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?

1 Solution

Accepted Solutions
Not applicable
Author

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

View solution in original post

5 Replies
Not applicable
Author

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

jagan
Luminary Alumni
Luminary Alumni

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.

mseeck75
Partner - Contributor III
Partner - Contributor III

Hi,

please try this:

getfieldselections(Field1,',',getpossiblecount(Field1))

BR

Matthias

Not applicable
Author

try this:

=getfieldselections(Fieldname,',',8)

8 is the number of fields, so you can adjust it urself

Not applicable
Author

Thanks for the answer.

It's working fine