Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

select all in listbox

Hello

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

Hasil gambar untuk select all listbox

1 Solution

Accepted Solutions
surendraj
Specialist
Specialist

1.PNG

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.

View solution in original post

8 Replies
Chanty4u
MVP
MVP

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.

Anonymous
Not applicable
Author

yes I already offered those solutions you suggest

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

Anonymous
Not applicable
Author


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.

PrashantSangle

Hi,

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

It will automatically select all values from list box

Regards,

Prashant

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
priyasawant
Creator II
Creator II

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

Capture list box.PNG

Untitled.png

surendraj
Specialist
Specialist

1.PNG

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.

sasikanth
Master
Master

HI

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

Anonymous
Not applicable
Author

great trick!

thanks