Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

Listbox limit possible selections based on another field

I'd like to be able to limit the available selections in a listbox based on a selection made on another specific chart. Using the function P (possible) doesn't work because as soon as a single selection is made in the listbox - the other possibilities go away. Sorting by frequency is also not as useful (even with show alternatives) as the list is very long. I'm not sure how I'd use set analysis for this - are there any suggestions?

I've attached a sample qvw to hopefully illustrate what I would like

1 Solution

Accepted Solutions
Highlighted
Specialist
Specialist

Hello Cary, give this a try

 

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

 

The Only( {$}) part will have the listbox only show possible values

The <F1> part will not reduce the shown list by any selections in that field

View solution in original post

4 Replies
Highlighted
MVP
MVP

maybe

=aggr(only({<City= P({<City=>}City)>}City),City)

Highlighted
Specialist III
Specialist III

using maxgro‌ expression,i have enabled conditional view on list boxes.

check the attached.

Highlighted
Specialist
Specialist

Hello Cary, give this a try

 

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

 

The Only( {$}) part will have the listbox only show possible values

The <F1> part will not reduce the shown list by any selections in that field

View solution in original post

Highlighted
Contributor
Contributor

Thanks all - while both options gave me the solution - Evan's was simpler in calculation time