Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Creating a Dynamic Listbox

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.

1 Solution

Accepted Solutions

Re: Creating a Dynamic Listbox

or

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


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

QlikCommunity_Thread_168201_Pic3.JPG



hope this helps


regards


Marco

5 Replies

Re: Creating a Dynamic Listbox

Hi,

one solution could be:

=Aggr(Metrics, Metrics)

QlikCommunity_Thread_168201_Pic1.JPG

QlikCommunity_Thread_168201_Pic2.JPG

hope this helps

regards

Marco

Re: Creating a Dynamic Listbox

or

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


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

QlikCommunity_Thread_168201_Pic3.JPG



hope this helps


regards


Marco

mov
Esteemed Contributor III

Re: Creating a Dynamic Listbox

Try a drill-down group:  Division -> Metrics

Not applicable

Re: Creating a Dynamic Listbox

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

Re: Creating a Dynamic Listbox

nice that it worked.

please select a correct answer.

thanks

regards

Marco

Community Browser