topic Re: Dynamic Listboxes in QlikView https://community.qlik.com/t5/QlikView/Dynamic-Listboxes/m-p/687566#M1082223 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>You can use an expression like this in your listbox:</P><P></P><P>=Aggr(Only(Country), Country)</P><P></P><P>Or</P><P></P><P>=Aggr(Only({&lt;Country=&gt;} Country), Country) (which should not collapse to a single country if you select one)</P><P></P><P>HTH</P><P>Jonathan</P><P></P><P>Edit: fixed second expression (missing &lt;, &gt;)</P></BODY></HTML> Tue, 01 Jul 2014 11:12:13 GMT jonathandienst 2014-07-01T11:12:13Z Dynamic Listboxes https://community.qlik.com/t5/QlikView/Dynamic-Listboxes/m-p/687563#M1082219 <HTML><HEAD></HEAD><BODY><P>Hi all, </P><P></P><P>How can I dynamically update the Country listbox to show only the countries related to the Region? So for example, when I select 'South East Asia' in Region, I only want it to to show 'India, Indonesia, Malaysia, Phillipines, Singapre, Thailand and Vietnam. Likewise, if I select 'Pacific' in Region, it will only show New Zealand and Australia. </P><P></P><P><IMG alt="RegionCountry.JPG.jpg" class="jive-image" src="https://community.qlik.com/legacyfs/online/61510_RegionCountry.JPG.jpg" /></P><P></P><P><IMG alt="RegionCountry1.JPG.jpg" class="jive-image" src="https://community.qlik.com/legacyfs/online/61517_RegionCountry1.JPG.jpg" /></P></BODY></HTML> Tue, 01 Jul 2014 10:58:02 GMT https://community.qlik.com/t5/QlikView/Dynamic-Listboxes/m-p/687563#M1082219 2014-07-01T10:58:02Z Re: Dynamic Listboxes https://community.qlik.com/t5/QlikView/Dynamic-Listboxes/m-p/687564#M1082221 <HTML><HEAD></HEAD><BODY><P>Under properties in the general tab click on 'Hide Excluded'</P></BODY></HTML> Tue, 01 Jul 2014 11:03:43 GMT https://community.qlik.com/t5/QlikView/Dynamic-Listboxes/m-p/687564#M1082221 Anonymous 2014-07-01T11:03:43Z Re: Dynamic Listboxes https://community.qlik.com/t5/QlikView/Dynamic-Listboxes/m-p/687565#M1082222 <HTML><HEAD></HEAD><BODY><P>hi</P><P>Please find the Attached File</P></BODY></HTML> Tue, 01 Jul 2014 11:11:22 GMT https://community.qlik.com/t5/QlikView/Dynamic-Listboxes/m-p/687565#M1082222 sasikanth 2014-07-01T11:11:22Z Re: Dynamic Listboxes https://community.qlik.com/t5/QlikView/Dynamic-Listboxes/m-p/687566#M1082223 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>You can use an expression like this in your listbox:</P><P></P><P>=Aggr(Only(Country), Country)</P><P></P><P>Or</P><P></P><P>=Aggr(Only({&lt;Country=&gt;} Country), Country) (which should not collapse to a single country if you select one)</P><P></P><P>HTH</P><P>Jonathan</P><P></P><P>Edit: fixed second expression (missing &lt;, &gt;)</P></BODY></HTML> Tue, 01 Jul 2014 11:12:13 GMT https://community.qlik.com/t5/QlikView/Dynamic-Listboxes/m-p/687566#M1082223 jonathandienst 2014-07-01T11:12:13Z Re: Dynamic Listboxes https://community.qlik.com/t5/QlikView/Dynamic-Listboxes/m-p/687567#M1082224 <HTML><HEAD></HEAD><BODY><P>Many thanks, worked!</P></BODY></HTML> Tue, 01 Jul 2014 11:16:43 GMT https://community.qlik.com/t5/QlikView/Dynamic-Listboxes/m-p/687567#M1082224 2014-07-01T11:16:43Z