topic Re: Listbox limit possible selections based on another field in QlikView

Listbox limit possible selections based on another field

Anonymous — Fri, 16 Oct 2015 16:44:42 GMT

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

Re: Listbox limit possible selections based on another field

maxgro — Fri, 16 Oct 2015 16:56:42 GMT

maybe

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

Re: Listbox limit possible selections based on another field

Qrishna — Fri, 16 Oct 2015 17:06:52 GMT

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

check the attached.

Re: Listbox limit possible selections based on another field

evan_kurowski — Fri, 16 Oct 2015 17:08:22 GMT

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

Re: Listbox limit possible selections based on another field

Anonymous — Fri, 16 Oct 2015 17:33:11 GMT

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