topic "select all" in List Box or Multi Box. in QlikView

"select all" in List Box or Multi Box.

Thu, 29 Sep 2011 14:49:26 GMT

Hi All,

Can I create a "select all" item in my List Box ?

Thanks,

"select all" in List Box or Multi Box.

sicilianif — Thu, 29 Sep 2011 14:56:13 GMT

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.

Frank

Re: "select all" in List Box or Multi Box.

its_anandrjs — Thu, 29 Sep 2011 15:02:27 GMT

Hi,

See the attached sample file

HTH

Rgds

Anand

"select all" in List Box or Multi Box.

Thu, 29 Sep 2011 15:09:03 GMT

Thank but I only have the personal edition so I can't open it !

"select all" in List Box or Multi Box.

Thu, 29 Sep 2011 15:11:27 GMT

Thank. I'll use the "right clicks on the list box they can choose "Select All" as a work around. Just curious how do you do it ? The field come from a SQL statement.

"select all" in List Box or Multi Box.

SunilChauhan — Thu, 29 Sep 2011 15:15:49 GMT

take a button

go to properties->Action->Add->selection->Select in field->Ok

in field write filed name which is in list or expression which is in list

and

in Search string type *

then ok

now click on button

it wil select all value in list box

Re: "select all" in List Box or Multi Box.

its_anandrjs — Thu, 29 Sep 2011 15:22:27 GMT

Hi,

Take a button and on right click select properties

Actions -> Add Action -> Selection -> Select in Field (Select Your Field Here) -> in Search String type *

and save it

Rgds

Anand

"select all" in List Box or Multi Box.

Thu, 29 Sep 2011 15:34:41 GMT

Thank you for the suggestion but my users don't want a "button" to select all values of a list box. What they want is a "select all" item in the list box. Their existing dashboard (written in OBIEE) have this so they want the same look and feel.

"select all" in List Box or Multi Box.

SunilChauhan — Thu, 29 Sep 2011 15:36:54 GMT

select all by draging and lock them