topic Re: Select Multiple Items in Listbox on Sheet Activation in QlikView

Select Multiple Items in Listbox on Sheet Activation

akile002 — Wed, 10 Apr 2013 14:14:26 GMT

I have a listbox with multiple numbers. When the sheet is activated, I want the numbers 41 and 44 selected. Is it possible to do this?

Re: Select Multiple Items in Listbox on Sheet Activation

Gysbert_Wassenaar — Wed, 10 Apr 2013 16:32:41 GMT

Yes, you can use the OnActivateSheet sheet trigger to execute a Select in Field action. Open the sheet properties window and select the Triggers tab. Click on the Add Action(s)... button under OnActivateSheet. Click on the Add button to add an action. Choose Select in Field and click on OK. Next enter the field name of the field you want to select the numbers in. Enter as search string (41|44). Click on OK and again OK to add the action to the trigger.

Re: Select Multiple Items in Listbox on Sheet Activation

akile002 — Thu, 11 Apr 2013 14:23:07 GMT

Thank you. This worked perfectly.

Re: Select Multiple Items in Listbox on Sheet Activation

Wed, 23 Oct 2013 07:38:49 GMT

How do I do when the listbox values are text ?

I have tried the pipe but I only get first value selected upon activation of the sheet

Re: Select Multiple Items in Listbox on Sheet Activation

israrkhan — Wed, 23 Oct 2013 07:54:04 GMT

Hi Fredrik,

in case of text box try like below:

in search string. let say you have these three values.

='(Fulfilled | "Partially Fulfilled" | Closed)'

you saw the " " around Partially Fulfilled value, because it has space, its is one value "Partially Fulfilled"

hope it helps..

Re: Select Multiple Items in Listbox on Sheet Activation

Wed, 23 Oct 2013 07:58:08 GMT

Thanks it works now

Re: Select Multiple Items in Listbox on Sheet Activation

dmohanty — Thu, 20 Jan 2022 05:27:02 GMT

Hello @Gysbert_Wassenaar - hope you are doing good.

How to get the regular display in Current Selection Box like 41, 44 instead of (41|44), even though we click thru button ?