topic Re: exclude values from a list box in QlikView

exclude values from a list box

chriscools — Mon, 06 Jun 2011 20:17:13 GMT

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

Re: exclude values from a list box

johnw — Mon, 06 Jun 2011 20:32:03 GMT

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.

Re: exclude values from a list box

Mon, 06 Jun 2011 20:47:37 GMT

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

exclude values from a list box

chriscools — Mon, 06 Jun 2011 21:00:58 GMT

thanx! you saved the day!