topic Re: Exclude (filter out) certain values from List Box in QlikView

Exclude (filter out) certain values from List Box

Mon, 29 Feb 2016 21:02:17 GMT

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

Re: Exclude (filter out) certain values from List Box

swuehl — Mon, 29 Feb 2016 21:44:05 GMT

I think you want to use the AND operator here:

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

try

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

Re: Exclude (filter out) certain values from List Box

Mon, 29 Feb 2016 21:52:10 GMT

Hi,

You can try this

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

Philippe

Re: Exclude (filter out) certain values from List Box

Mon, 29 Feb 2016 22:18:05 GMT

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.

Re: Exclude (filter out) certain values from List Box

Mon, 29 Feb 2016 22:46:14 GMT

Sorry i have forgotten à ')'.

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