How to Just show the available values and hidden the rest of values in list boxes

[arixooo123]

Hello Guys!

I like to have 2 List Boxes indicating State(Province) and City, as you know number of possible cities are too many and finding the desired city might be difficult in these situations.

I want to make a change in my document as when a user select a State, He/She would just see the available cities of that state and not all the cities of country (i know qlikview high-lighten the available values).

thanks in advance

[MK_QSL · Accepted solution]

Go to the General tab of City list box and select hide excluded...

Another way is use below as an expression in List Box instead of City dimension...

=Aggr(City,City)

[PrashantSangle]

Hi,

Use in list box

Expression,

Aggr(City,City)

Regards