Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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?

Tags (2)
1 Solution

Accepted Solutions
Not applicable

Re: NOT in listbox selections

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

5 Replies
Not applicable

Re: NOT in listbox selections

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

MVP
MVP

Re: NOT in listbox selections

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
New Contributor III

Re: NOT in listbox selections

Hi,

please try this:

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

BR

Matthias

Not applicable

Re: NOT in listbox selections

try this:

=getfieldselections(Fieldname,',',8)

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

Not applicable

Re: NOT in listbox selections

Thanks for the answer.

It's working fine

Community Browser