Multi Select Drop Down

[Anonymous]

Hi,

I have a Multi Box Object as

Options->A

              B

              C

              D

I am creating a button which on selecting should change the values in the Multi Box to A, B and C.

The usual way is

-Create an Action

-Select In Field

-Give the field name in Field

-Enter Search String in the Search String.

I am able to write ='A' in the Search String. How do I write multiple values in the Search String.

[MK_QSL]

(A|B|C)

[swuehl]

Try

("A"|"B"|"C")

[without a leading equal sign]

[Anonymous]

Thanks guys. Let me try it and get back to you.

[Anonymous]

Can we use not to select one particular value and select the rest?

In this case, how can we select A,B,C but not D?

The reason am asking about excluding a value is because, if my options are too many, it's easier to exclude a single value rather than including too many values.

For example, if I have to select A to Y but not Z, easier would be excluding 'Z' rather than defining all 25 values.

[swuehl · Accepted solution]

Have a look at

Compound Search - demystified | Qlik Community

Maybe something like

(* ^ Z)

[Anonymous]

swuehl,

Should this work in the requirement I gave here? I tried but I don't see the button selecting A to Y but not Z in my case.

[Anonymous]

I am creating a button and adding "Select in Field'' action. How do I define Search String here if I have to select alphabets A to Y but not Z in my Multi Box, when I click the button?

[swuehl]

Seems to work for me

[Anonymous]

Hi Swuehl,

You are generating the Data using

LOAD Chr(ORD('A')+REcno()-1) as Char

Autogenerate 26;

This itself is selecting A to Y and excluding Z, right?

I need to create an Action in a button using 'Select in Field' so that when i click the button, A to Y values are selected, leaving 'Z'. This should happen after I select the button, not by default. I need to mention some logic in the 'Search String' field of Buttons->Actions->Select in Field->Search String