topic Display only available options in list box in QlikView https://community.qlik.com/t5/QlikView/Display-only-available-options-in-list-box/m-p/158090#M33318 <HTML><HEAD></HEAD><BODY><P>you have two option:</P><P>1) Set "Hide Excluded Values" from General Tab about properties of your listbox, but it works only if you click on the listbox.</P><P>2) Modify the script using this step :</P><UL><LI>LOAD Country LIST</LI><LI>LOAD CITIES List whit this clause "WHERE EXISTS(COUNTRY_FIELD)" when you fetch data about the cities.</LI></UL><P>By this way, You will get only cities related to your known countries</P></BODY></HTML> Wed, 24 Feb 2010 17:19:32 GMT 2010-02-24T17:19:32Z Display only available options in list box https://community.qlik.com/t5/QlikView/Display-only-available-options-in-list-box/m-p/158089#M33317 <HTML><HEAD></HEAD><BODY><P>Is it possible to set a list box to display only the available options?</P><P>E.g IF I have two list boxes of for Country and anotehr for city, I only wnat to show the cities that a related to the country in the list box.</P></BODY></HTML> Wed, 24 Feb 2010 17:10:51 GMT https://community.qlik.com/t5/QlikView/Display-only-available-options-in-list-box/m-p/158089#M33317 alan_grn 2010-02-24T17:10:51Z Display only available options in list box https://community.qlik.com/t5/QlikView/Display-only-available-options-in-list-box/m-p/158090#M33318 <HTML><HEAD></HEAD><BODY><P>you have two option:</P><P>1) Set "Hide Excluded Values" from General Tab about properties of your listbox, but it works only if you click on the listbox.</P><P>2) Modify the script using this step :</P><UL><LI>LOAD Country LIST</LI><LI>LOAD CITIES List whit this clause "WHERE EXISTS(COUNTRY_FIELD)" when you fetch data about the cities.</LI></UL><P>By this way, You will get only cities related to your known countries</P></BODY></HTML> Wed, 24 Feb 2010 17:19:32 GMT https://community.qlik.com/t5/QlikView/Display-only-available-options-in-list-box/m-p/158090#M33318 2010-02-24T17:19:32Z