On Sheet Activate> Select Multiple Values in a Fields

[#1]

I attempting to set up a sheet where 'On Sheet Activate' multiple values for a field can be selected in the search string.

For example. Triggers> Select in Field> salesrep_id > Search String> =1022, 3022, etc...

I have tried many combination's of () and keywords in the search string. I have yet to find the correct combination/syntax. Selecting one value works fine but multiple values does not.

The last entry in the below post is exactly what I am after.

http://community.qlik.com/forums/p/16933/66257.aspx

I would also be okay with the data being displayed within a pivot table. If I want an expression to show only: salesrep_id = 3202 AND 1022 AND etc..

The second of the two events would be the most useful. Thanks for any ideas you have to offer.

[#2]

I had exactly the same issue and the ToggleSelect feature worked perfectly. Thank you NMiller!

[jarno_loubser]

I was able to achieve this by first performing a select in field (on sheet activation) of the one value in the list I do not want and then performing a select excluded (also on sheet activation).

I was lucky though in that only one value wasn't in my desired list.

[#4]

Thank you very much for the clue on how to issue multiple fields on a sheet activation !  The Select In Field and followup of Toggle Select(s) works perfect.

Regards,

Rick

[#5]

Thank you very much for the clue on how to issue multiple fields on a sheet activation !  The Select In Field and followup of Toggle Select(s) works perfect.

Regards,

Rick

[#6]

Thank you very much for the clue on how to issue multiple fields on a sheet activation ! The Select In Field and followup of Toggle Select(s) works perfect.

Regards,

Rick

[#7]

Thank you very much for the clue on how to issue multiple fields on a sheet activation ! The Select In Field and followup of Toggle Select(s) works perfect.

Regards,

Rick

[#8]

Ryan,

I found your answer to be the best. Along with Neil Millers

Step by Step Instructions:

Open the properties of your sheet.

Step 1 - Within the Sheet Object Even Triggers - click "Add Action" , click "Add", then select "Selection" and then select "Select in Field" and click "OK"

Step 2 - Select your Field that you want to filter on (or type it), and then type in the data within the search string (example sales id - 1234)

Step 3 - Then Within the Sheet Object Even Triggers - click "Add Action" , click "Add", then select "Selection" and then select "Toggle Select" and click "OK"

Step 4 - Select your Field that you want to filter on (or type it), and then type in the data within the search string (example sales id - 5678)

I would also added a Lock Field within the Sheet Object

and subsequently added an Unlock Fields on the "OnLeaveSheet".

Regards,

Paul