topic Re: List box expression with selection indicator in QlikView

List box expression with selection indicator

erikzions — Fri, 10 Jun 2016 22:29:42 GMT

I have created a dynamic list box so I can have any amount of filters without taking up any additional space. It works wonderfully. The only caveat is that it does not indicate when a selection has been made on a field, the way a list box or multi box would. I have tried my best to make a getcurrentselections function work on a dynamic field.

Is there a way to put an indicator in an expression to show if there is a selection has been made?

Included is a dummy example file.

Re: List box expression with selection indicator

swuehl — Fri, 10 Jun 2016 22:37:14 GMT

Not exactely sure what you are asking for, I do see the selection on value male as in a normal list box:

Re: List box expression with selection indicator

Anonymous — Sun, 12 Jun 2016 10:23:52 GMT

Eric,

try this expression

=concat({1}
aggr( concat({<_FilterField=>} if(_FilterField='email', GetFieldSelections(email),
if(_FilterField='first_name',
GetFieldSelections(first_name)))),_FilterField))

in your "Field to Filter On" List Box. This will display the selections made in all the fields.

If you don't have too many fields, this could be a solution.

I think $ sign expansion will not work as it is executed "too early".

Regards

Norbert

Re: List box expression with selection indicator

Anonymous — Thu, 16 Jun 2016 08:48:01 GMT

Eric, I am now using this expression in my List Box:

=subfield(
left(
mid(GetCurrentSelections('|','~'),index('|' & GetCurrentSelections('|','~'),'|' & only({1}$Field))),
index(
mid(GetCurrentSelections('|','~'),index('|' & GetCurrentSelections('|','~'),'|' & only({1}$Field)))&'|','|')-1)
,'~',2)

For sorting I use:

=index('|' & GetCurrentSelections('|','~'),'|'&only({1}$Field))

As Field I use $Field, so that my List Box currently shows all avilable fields and if a selection is made you can see the selection in the expression.

Regards

Norbert

Re: List box expression with selection indicator

erikzions — Thu, 16 Jun 2016 14:34:32 GMT

That looks perfect!!! I am not going to display the actual selections, just an asterisk. But this gets me what I need. Your awsome, thanks.