Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
drj12345
New Contributor III

Multi Select Drop Down

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.

1 Solution

Accepted Solutions
MVP
MVP

Re: Multi Select Drop Down

14 Replies
MVP
MVP

Re: Multi Select Drop Down

(A|B|C)

MVP
MVP

Re: Multi Select Drop Down

Try

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

[without a leading equal sign]

drj12345
New Contributor III

Re: Multi Select Drop Down

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

drj12345
New Contributor III

Re: Multi Select Drop Down

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.

MVP
MVP

Re: Multi Select Drop Down

drj12345
New Contributor III

Re: Multi Select Drop Down

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.

drj12345
New Contributor III

Re: Multi Select Drop Down

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?

MVP
MVP

Re: Multi Select Drop Down

Seems to work for me

drj12345
New Contributor III

Re: Multi Select Drop Down

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