Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
MarcoWedel

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

View solution in original post

5 Replies
MarcoWedel

Hi,

one solution could be:

=Aggr(Metrics, Metrics)

QlikCommunity_Thread_168201_Pic1.JPG

QlikCommunity_Thread_168201_Pic2.JPG

hope this helps

regards

Marco

MarcoWedel

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

Anonymous
Not applicable
Author

Try a drill-down group:  Division -> Metrics

Not applicable
Author

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

MarcoWedel

nice that it worked.

please select a correct answer.

thanks

regards

Marco