selecting all values different from one particular value

[cacciad]

hello  , can someone help me ?

Im trying to create an action on a buttom to select all values different from on particular value I want to exclude.

I have tried this ..

='=sous_offre <> Interne'

but it does not work.. I don't know the syntax for "different from"... can someone help me ? merci ! daniel

[GaryGiles · Accepted solution]

There are 2 different approaches you could use:

Approach 1. Choose "Select values in a field" as your button Action, select your field [sous_offre], and use the following for the Value:  =Concat({$<[sous_offre]-={'Interne'}>} Distinct [sous_offre],';')

Approach 2. Same as approach 1, but as a value, use ='Interne', then add a second action to "Select excluded" for the field [sous_offre]

Either approach should give you the desired filtering.

[cacciad]

gary could you detail approach 2 as approach 1 seems to be exluding to many values.. might me my data..

merci !

[GaryGiles]

Not sure I understand what you mean by excluding to many values. 

Other fields selections could be affecting the list being built via the concat statement.  Let's us a 1 instead of $ as our Identifier.  Like this:

=Concat({1<[sous_offre]-={'Interne'}>} Distinct [sous_offre],';')

Does that help?

[cacciad]

hello gary , I know what's happening some of the values of the field sous offre are empty.... but I want them as well in the selection and they get excluded....

[GaryGiles · Accepted solution]

Okay.  So Approach 2 should accomodate for empty values in [sous offre].

Approach 2. Choose "Select values in a field" as your button Action, select your field [sous_offre], and use the following for the Value:  ='Interne'      Then, add another action to the same button and choose "Select excluded" and specify the field [sous_offre].  The first action will select 'Interne' and the second action will select all values currently excluded from [sous offre] (all but 'Interne').  It should happen quickly, so the user shouldn't be able to perceive 2 actions.

Hope that helps.

[cacciad]

Works fine Gary. Many thanks again !!!