topic List box used for filtering - need to exclude a value in QlikView

List box used for filtering - need to exclude a value

Thu, 15 Mar 2012 16:09:06 GMT

This should be easy..

I have a list box that allows the user to filter on values to be displayed in a separate chart. The values are

CLOSED

SYSTEM SUPPORT AND MAINTENANCE

PENDING

ESG ACTIVITIES

ACTIVE

I need to exclude ESG ACTIVIES from the list box.

If anyone can point me in the right direction I’d appreciate it.

jvitantonio — Thu, 15 Mar 2012 16:12:07 GMT

Go to the list box properties. In the Field drop down, select <Expression> and write:

=IF (yourField <>'ESG ACTIVITIES', yourField)

Thu, 15 Mar 2012 16:17:46 GMT

Thanks!