topic Re: Filter Issue in QlikView

Filter Issue

nagarjuna_kotha — Fri, 10 Apr 2015 11:09:44 GMT

Hi all,

I have a list box, in that i have 12 Business ,

and i have created on text box to show selected value in that(GetfieldSelections())

What i want is if i select more than 6 it is showing All Excluding Value.

Can any one tell ,how to resolve this problem ?

Regards,

Nagarjuna

Re: Filter Issue

anbu1984 — Fri, 10 Apr 2015 11:17:34 GMT

=GetFieldSelections(Field,',',100)

Re: Filter Issue

nagarjuna_kotha — Fri, 10 Apr 2015 11:20:26 GMT

Thanks.Let me Cheak......

Re: Filter Issue

simsondevadoss — Fri, 10 Apr 2015 11:20:59 GMT

Missing Manual - GetFieldSelections() + Bonus Example

check the above link

Re: Filter Issue

Fri, 10 Apr 2015 11:29:19 GMT

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 )

Re: Filter Issue

hariprasadqv — Fri, 10 Apr 2015 11:55:15 GMT

Hi Nag!,

Try This

=GetFieldSelections(Business,',',12)

Syntax: =GetFieldSelections(Name_of_the_Fiels,Seperator,Maximum_Number_of_values_can_select)