topic Re: Creating a Dynamic Listbox in QlikView

Creating a Dynamic Listbox

Fri, 12 Jun 2015 19:15:12 GMT

Hello,

I am trying to create a List box that filters its displayed values based on selection within another list box. The two list boxes are Divisions and Metrics. When I select any given Division, I want that divisions metrics to display within the Metrics box. However, I am having trouble hiding those that are not selected.

I go to the Metrics listbox, and on the General tab I select <expression> as the field type, within which I write:

=GetCurrentSelections(Divisions), which on returns, when selected, Divisions: (Selection Made), ex: Divisions: Finance.

Any and all help is appreciated. Thanks.

Re: Creating a Dynamic Listbox

MarcoWedel — Fri, 12 Jun 2015 23:03:10 GMT

Hi,

one solution could be:

=Aggr(Metrics, Metrics)

hope this helps

regards

Marco

Re: Creating a Dynamic Listbox

MarcoWedel — Fri, 12 Jun 2015 23:14:39 GMT

=Aggr(Only({$<Metrics=>}Metrics), Metrics)

if you want to keep the division metrics visible even with metric selections.

hope this helps

regards

Marco

Re: Creating a Dynamic Listbox

Anonymous — Sat, 13 Jun 2015 03:42:39 GMT

Try a drill-down group: Division -> Metrics

Re: Creating a Dynamic Listbox

Mon, 15 Jun 2015 14:53:14 GMT

Thank you all for the fast reply. That was exactly what I was looking for!

Re: Creating a Dynamic Listbox

MarcoWedel — Mon, 15 Jun 2015 23:51:15 GMT

nice that it worked.

please select a correct answer.

thanks

regards

Marco