Exclude (filter out) certain values from List Box

[#1]

Hi,

This "should' be an easy one.

I'm using a list box as a filter for my data presentation.  There are some blanks and unwanted values in my data that I do not want to show in the list box.  I'm not able to filter them out.

For example, the data contains only these values (2015, 2016, 2017, N/A, 0, blank cells)

I want to only show 2015, 2016, 2017 in my list box.  I'm using an expression to try to filter out the other stuff.

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

Unfortunately...not working. 

Please advise.

Thank you

[swuehl · Accepted solution]

I think you want to use the AND operator here:

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

or

try

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

[#3]

Hi,

You can try this

=if (len ([Year]>3, [Year])

Philippe

[#4]

Hi trung.nguyen,

You can try 'If' Expression in the list box as below

=if(Year <> '0',

if(Year <> 'N/A',

if(Year <> ' ', Year)))

QVW Attached.

[#5]

Sorry i have forgotten à ')'.

=if (len ([Year])>3, [Year])