topic MULTIPLE SELECTIONS IN A TRIGGER in QlikView

MULTIPLE SELECTIONS IN A TRIGGER

christian77 — Tue, 05 Jul 2011 10:40:19 GMT

Hi:

I have a trigger in a button that selects in a field. I can´t find the right Search String expression to select more than one value at a time. The field is a numeric one that takes values from 1 to 9.

I have tried several ways:

7,8

‘7’,’8’

=’7’,’8’

={‘7’,’8’}

It doesn’t work.

Can anyone help me?

Thanks.

MULTIPLE SELECTIONS IN A TRIGGER

Tue, 05 Jul 2011 10:56:17 GMT

Hello Christian,

if the field is num and you want to select 7 and 8 try this as search mask of the trigger:

(7|8)

regards, Roland

MULTIPLE SELECTIONS IN A TRIGGER

kaushiknsolanki — Tue, 05 Jul 2011 10:59:03 GMT

Hi,

Type in this fasion.

(7|8)

Regards,

Kaushik Solanki

MULTIPLE SELECTIONS IN A TRIGGER

raghavsurya — Tue, 05 Jul 2011 11:01:31 GMT

Hi,

Try putting it as (7|8)

Regards,

Raghav

Re: MULTIPLE SELECTIONS IN A TRIGGER

christian77 — Tue, 05 Jul 2011 11:05:36 GMT

Thank you all !!!!!!!!!!

It works perfectly.

I've choosen as correct the first one but they are all correct.

Re: MULTIPLE SELECTIONS IN A TRIGGER

subin6600 — Wed, 23 Nov 2011 06:18:57 GMT

Hi if the field value is a text how can the selections be made??I need 4 options to be select like say , ABC, BCD,CDE,EFG

MULTIPLE SELECTIONS IN A TRIGGER

subin6600 — Wed, 23 Nov 2011 09:36:03 GMT

any one who is trying to get the syntax??Plz its urgent..

Re: MULTIPLE SELECTIONS IN A TRIGGER

Wed, 30 Nov 2011 07:02:00 GMT

Hi Ronald Kunle,

Could you please let me know how to get the symbol that is being used between the numbers 7 and 8..

Thanks,

Lavanya

Re: MULTIPLE SELECTIONS IN A TRIGGER

Wed, 30 Nov 2011 11:05:13 GMT

Hi Lavanya,

this is the pipe-symbol "|" (=chr(124))

Re: MULTIPLE SELECTIONS IN A TRIGGER

Mon, 01 Oct 2012 14:35:09 GMT

If field value is a string, you can use that:

'ABC|BCD|CDE|EFG'

Regards