topic How can I remove a filter from a List Box? in QlikView

How can I remove a filter from a List Box?

Tue, 29 Apr 2014 19:22:01 GMT

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 — Tue, 29 Apr 2014 19:24:51 GMT

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 — Tue, 29 Apr 2014 19:43:54 GMT

List box Expression

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

Tue, 29 Apr 2014 19:47:36 GMT

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 — Tue, 29 Apr 2014 19:51:40 GMT

Check Enclosed File..

Tue, 29 Apr 2014 19:59:43 GMT

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!