Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Check Enclosed File..
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')
List box Expression
=aggr(only({<Country={'Belgium','Denmark'}>}Country),Country)
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
Check Enclosed File..
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!