topic Re: Append to a list box action in QlikView

Append to a list box action

Mon, 29 Sep 2014 20:37:55 GMT

Hi,

This is the current behaviour of a button Selection action :

"Select in Field" action : clears the current selection of the target list box and then adds the search string to it.

"Toggle Select" action: , toggles the target box selection state of the search string.

But, there is no "Append Select" to append the search string to the existing selection of the target list box. Is there a workaround?

Re: Append to a list box action

Anonymous — Mon, 29 Sep 2014 21:09:44 GMT

Hi,

you can use this expression in a select in field action:

= chr(40) & concat(distinct YourField, '|' ) & '|YourValue' &chr(41)

Best Regards

Stefan

Re: Append to a list box action

Mon, 29 Sep 2014 22:31:46 GMT

Thank You. After tweaking it a bit to fit my app it worked great.

Re: Append to a list box action

Tue, 30 Sep 2014 01:48:51 GMT

Hi,

I just noticed that YourField returns all possible values if nothing is already selected in the target list. So when something is added to the list for the first time, everything becomes green (selected). I tried to replace YourField with GetFieldSelections(YourField) function but that does not work. Here is my actual button Search String:

=chr(40) & concat(distinct replace(store_name,store_name,'"'&store_name&'"'), '|' ) & '|' & '$(vAddToStores)' &chr(41)

Is there a simple solution for this?

Re: Append to a list box action

Anonymous — Tue, 30 Sep 2014 05:03:33 GMT

Hi,

This should work:

= If(getselectedcount (store_name)> 0,chr(40) & concat(distinct replace(store_name,store_name,'"'&store_name&'"'), '|' ) & '|' & '$(vAddToStores)' &chr(41))

Best regards

Stefan

Re: Append to a list box action

Tue, 30 Sep 2014 18:00:15 GMT

yes, it does. Thank you.