How can I remove a filter from a List Box?

[#1]

Hello, I'd like to know how to remove filters from a list box.

I have a master table for Country and when I create my list box it will show the following:

Belgium

Holland

Denmark

England

I only want the list box to show Belgium and Denmark.

How can I achieve this?

Thanks,

Fernando

[MK_QSL]

Write below in List Box Expression

IF(Country = 'Belgium' or Country = 'Denmark', Country)

2nd Option...

Write below in List Box Expression

=Pick(Match(Country,'Belgium','Denmark'),'Belgium','Denmark')

[venkatg6759]

List box Expression

=aggr(only({<Country={'Belgium','Denmark'}>}Country),Country)

[#4]

Hi Manish, thanks for your suggestions. I used the formula in the expression for my list box. However, when typing it will get this:

(List Box) Country;

Belgium - Belgium

Holland -

Denmark - Denmark

England -

Instead of being:

(List Box) Country:

Belgium

Denmark

Any advice?

Thank you in advance.

Fernando

[MK_QSL · Accepted solution]

Check Enclosed File..

[#6]

Thanks, I was going into the tab "Expression" and that's why it didn't worked.

However, with your example it works like charm!

Thank you!