exclude values from a list box

[chriscools]

Hello,

is there a way that i can make a selection to show not all the values in a list box, but only the values  that correspond with

a certain country.

thanx!

chris

[johnw · Accepted solution]

You can use an expression for values in a list box, so you could do this:

if(Country='Brazil',City)

That would then give you a list box of only cities in Brazil.  Another alternative is to do the logic in the script:

,if(Country='Brazil',City) as CityInBrazil

Then you can make a list box for CityInBrazil.

[#3]

Hi Chris,

If you are dealing with two or more listbox's what john replied is one of the best options and if you don't want to write any conditions and you are using qlikview 10 then go to listbox properties and then u have a option in listbox general properties to hide exclude . You can hide the un related data in both the listboxes by selecting the hide exclude feature in both the boxes

here i'm attaching an example for that ...

thanks a lot

Bradd

[chriscools]

thanx! you saved the day!