topic Re: Multiple Select Trigger in QlikView

Multiple Select Trigger

Thu, 21 Aug 2014 16:03:25 GMT

I have found how to set a selection on activating a sheet using Trigger--->OnActivateSheet--->AddAction--->Select in Field--->Field--->Search String

Having entered a string ='2013/14' this selects 2013/14 as expected. What if I wanted to select both 2013/14 and 2014/15 on sheet activation? I can't find a way of entering both strings (such as an AND statement or a + sign) or do I have to add it as a separate statement?

Any help appreciated.

Re: Multiple Select Trigger

Anonymous — Thu, 21 Aug 2014 16:06:40 GMT

use =('2013/14'|'2014/15') in search string for field. you can do more than two...just separate the strings using the pipe (|) character.

from help for "Add Action Dialog",

Select in Field

Selects the values and fields that are specified.
In the Search String you can specify a search mask, e.g.
(A|B) will select both A and B.

Re: Multiple Select Trigger

jagan — Thu, 21 Aug 2014 16:08:52 GMT

Hi,

Try like this

Give search string as ("2013/14"|"2014/15")

Regards,

Jagan.

Re: Multiple Select Trigger

rwunderlich — Thu, 21 Aug 2014 16:13:39 GMT

You may also use the "Toggle Select" action, which is an additive select.

-Rob

http://masterssummit.com

http://robwunderlich.com