topic Re: Multi Select Drop Down in QlikView

Multi Select Drop Down

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have a Multi Box Object as

Options->A

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.

Re: Multi Select Drop Down

MK_QSL — Tue, 26 Apr 2016 18:34:19 GMT

(A|B|C)

Re: Multi Select Drop Down

swuehl — Tue, 26 Apr 2016 18:34:19 GMT

Try

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

[without a leading equal sign]

Re: Multi Select Drop Down

Anonymous — Tue, 26 Apr 2016 18:36:19 GMT

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

Re: Multi Select Drop Down

Anonymous — Tue, 26 Apr 2016 20:28:30 GMT

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.

Re: Multi Select Drop Down

swuehl — Tue, 26 Apr 2016 20:36:06 GMT

Have a look at

Compound Search - demystified | Qlik Community

Maybe something like

(* ^ Z)

Re: Multi Select Drop Down

Anonymous — Tue, 26 Apr 2016 20:39:52 GMT

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.

Re: Multi Select Drop Down

Anonymous — Tue, 26 Apr 2016 20:41:48 GMT

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?

Re: Multi Select Drop Down

swuehl — Tue, 26 Apr 2016 20:47:45 GMT

Seems to work for me

Re: Multi Select Drop Down

Anonymous — Tue, 26 Apr 2016 20:52:47 GMT

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

Re: Multi Select Drop Down

Anonymous — Tue, 26 Apr 2016 20:53:43 GMT

Sorry, got it. You are using the logic in the Text Box. I get it now...Thanks

Re: Multi Select Drop Down

swuehl — Tue, 26 Apr 2016 20:55:15 GMT

No, the script should return A to Z.

You should see all field values in the list box and clicking the text box should trigger the select in field action.

Re: Multi Select Drop Down

Anonymous — Fri, 03 Jun 2016 14:42:12 GMT

If I have more than one values that should be eliminated, how do I do it?

For example, in this case, if I have to select all the alphabets from A to V but not X, Y, Z?

Writing (* ^ X,Y,Z) isn't working.

Re: Multi Select Drop Down

swuehl — Fri, 03 Jun 2016 14:47:24 GMT

(* ^ (X|Y|Z))

Re: Multi Select Drop Down

Anonymous — Fri, 03 Jun 2016 16:14:27 GMT

Thank you so much swuehl.