Disabling "Other" in a listbox...

[#1]

Hi Folks,

In my data, I have many records that are tagged "Other" or "Unknown" that we dont want to search on.

is there a way to disable these choices in the list box?.  Any Direction would be appreciated.

thanks

-L

[Chanty4u]

u can try

=if( ([Year]<>' ' AND [Year]<>'0' AND [Year]<>'N/A'), [Year])

or

try

=If( [urfield] > 0 , [urfield])

[Kushal_Chawda]

either you create the separate field as

if(not wildmatch(lower(YourField),'*others*','*unknown*'),YourField) as NewField

Now use this NewField in lisbox

or in lisbox expression put the below expression

aggr(if(not wildmatch(lower(YourField),'*others*','*unknown*'),YourField),YourField)

[tamilarasu]

You can try list box expression as

=If(Not Match(FieldName, 'Other', 'Unknown'),FieldName)

or

=aggr(only({<FieldName-={'Other', 'Unknown'}>}FieldName),FieldName)

[Chanty4u]

Dimension :  =IF(field<> 'other', field)

[raman_rastogi]

Try this one

Listbox Expression

=If( field > 0 , field)

[#7]

Hi,

Try this:

[MayilVahanan · Accepted solution]

Hi

Try like this

Load *, if(Not Match(FieldName, 'Other', 'Unknown'),FieldName) As NewField from tablename;

Use NewField in listbox and chart as well.

Or, In Front End,

if(Not Match(FieldName, 'Other', 'Unknown'),FieldName)

[#9]

this one worked thank you