Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
ToddE
Contributor II
Contributor II

Customise a filter

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

Labels (2)
2 Solutions

Accepted Solutions
NitinK7
Specialist
Specialist

use filter pane and try below expression

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

View solution in original post

ToddE
Contributor II
Contributor II
Author

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 😊

View solution in original post

2 Replies
NitinK7
Specialist
Specialist

use filter pane and try below expression

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

ToddE
Contributor II
Contributor II
Author

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 😊