topic Re: NOT in listbox selections in QlikView

NOT in listbox selections

Tue, 30 Jul 2013 10:46:21 GMT

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?

Re: NOT in listbox selections

Tue, 30 Jul 2013 11:01:14 GMT

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

Re: NOT in listbox selections

jagan — Tue, 30 Jul 2013 11:02:28 GMT

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.

Re: NOT in listbox selections

mseeck75 — Tue, 30 Jul 2013 11:06:18 GMT

Hi,

please try this:

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

Matthias

Re: NOT in listbox selections

Tue, 30 Jul 2013 11:07:05 GMT

try this:

=getfieldselections(Fieldname,',',8)

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

Re: NOT in listbox selections

Tue, 30 Jul 2013 11:46:27 GMT

Thanks for the answer.

It's working fine