Customise a filter

[ToddE]

Hello Qlik Community

I want to remove a specific item from a filter.  The field name  applicable to the filter is [BusinessUnit Name].  I would like to remove any business units that contain "not managed" from the filter.

I'm sure there must be some code to achieve this, but I don't know what that is?

Can anyone help please?

Many thanks

[NitinK7 · Accepted solution]

use filter pane and try below expression

Aggr(only({<BusinessUnit -={'not managed'}>}BusinessUnit ),BusinessUnit )

[ToddE · Accepted solution]

Hi NitinK7

Thank you for responding.  I tried the expression you suggested, but all filter options disappeared.  I then tried entering as below (with "BusinessUnit Name" inside [], but that didn't work either.

=Aggr(only({<[BusinessUnit Name] -={'not managed'}>}[BusinessUnit Name] ),[BusinessUnit Name] )

So I tried the following and this has worked for me 😊!

=Aggr(only({<[BusinessUnit Name] -={"*not managed*"}>}[BusinessUnit Name] ),[BusinessUnit Name] )

Thank you for helping 😊