topic Re: select all in listbox in QlikView

select all in listbox

Anonymous — Fri, 24 Feb 2017 04:42:16 GMT

Hello

Is it possible to add 'select all' item inside the listbox like below image attached in Qlikview?

Re: select all in listbox

Chanty4u — Fri, 24 Feb 2017 04:44:10 GMT

try below

If the user right clicks on the list box they can choose "Select All".

Or you could add a button with an action to "Select in field", then for the selection just put *.

You could add a select all to the list, but there would be a lot of work to make the expressions use it correctly.

Re: select all in listbox

Anonymous — Fri, 24 Feb 2017 04:47:18 GMT

yes I already offered those solutions you suggest

but the user preferred to have an additional item in listbox to select all the list

Re: select all in listbox

Anonymous — Fri, 24 Feb 2017 04:56:04 GMT

Try adding extra 'Select all' in the field used for list box. Then use LEd check boxes as presentation.

Now add triggers in document properties on field change and field select such that if the getfieldselection (your field) is 'select all' then select all.

Re: select all in listbox

PrashantSangle — Fri, 24 Feb 2017 05:23:42 GMT

Hi,

One more solution is enter * in listbox search parameter and enter

It will automatically select all values from list box

Regards,

Prashant

Re: select all in listbox

priyasawant — Fri, 24 Feb 2017 06:27:17 GMT

Hi.. you can provide a select all option on the title

Re: select all in listbox

surendraj — Fri, 24 Feb 2017 06:43:17 GMT

I added 'select all' item in place of caption.(In listbox-->caption disable show caption)

Here I took 2 text objects

For

1.Select all.

2 windows checkbox icon.

And Finally disable

Layout-->Allow move/Size for all objects.(to fix the objects in required place)

Hope this help you!!

Edit:

Apply actions to both the text objects(Select in field-->Filed name--->*)

Make sure to select all fields in list box.

Re: select all in listbox

sasikanth — Fri, 24 Feb 2017 07:09:30 GMT

try this,

Let say your field name is YEAR having 4 values , try to create one inline load like below

LOAD * INLINE [

YEAR

ALL

];

GO to Settings--> Document properties --> Triggers--> Field event Triggers-->YEAR-->

onSelect actions--> Select in a field-->

Field Name :YEAR

Search string: =if(getFieldSelections(YEAR)='ALL','*',YEAR).

PFA, for reference

Re: select all in listbox

Anonymous — Mon, 27 Feb 2017 03:15:45 GMT

great trick!

thanks