filter pane exclusive

[Fab62400]

Hello,

Is it possible to have a filter pane in exclusive mode ?

And how to define a list and connect it to a field?
For example:
I have a filter containing a list of data but I wouldn't want all of the data to appear.
How to do ?

Thank you for your help

[Chanty4u]

can you explain  bit more. do you want to exclude any values from the filter ?

[Fab62400]

no I want to select only one data.

[Fab62400]

that is for the first question.
For the 2nd question, yes I want to exclude some data.

[MayilVahanan]

Hi @Fab62400 

Try like below in filter pane expression

=if(not Match(fieldName,'a','b'), fieldName)

it will exclude value a & b in field name and display the remaining values

[MayilVahanan]

Hi @Fab62400 

Or, create a new field in the script with exclude few values

Load *, if(not Match(fieldName,'a','b'), fieldName) as NewFieldName from ursource;

And use that field in the filter pane and check always one selectedvalue. 

[Fab62400]

ok Thank you , i will try.

[Fab62400]

Great it works  ! thank you.

and for my second question, do you have an idea?