Button - select excluded values

[#1]

Is it possible with a button to select everything EXECPT two values.

I can work out how to do one, as you do a simple 'Select in Field' action followed by a 'Select Excluded' action.

But when I try and insert a 'Toggle Select' action between those two actions it seems to be ignored.

What am I doing wrong?

[Gysbert_Wassenaar · Accepted solution]

You can try selecting the two values first with a search string like ("Value1"|"Value2") and then follow that up with the Select Excluded action to invert the first selection.

[tresesco]

Try 'select in field' like:

Search String= '('&Concat({<FieldName-={'Exclude1', 'Exclude2'}>} Distinct FieldName, '|') &')'

[#4]

that worked. Thanks Gysbert!

[Tank]

This solution works! Thank you, Tresesco.