Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
can you explain bit more. do you want to exclude any values from the filter ?
no I want to select only one data.
that is for the first question.
For the 2nd question, yes I want to exclude some data.
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
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.
ok Thank you , i will try.
Great it works ! thank you.