topic ListBox filtering in QlikView

ListBox filtering

simonb2013 — Tue, 20 Jun 2017 10:21:40 GMT

I have a data island with 2 fields : Category; Option

[Option] is displayed to the end user in a listbox.

Depending on other general selections, I want to limit the [Option]s displayed.

So I have a trigger that filters [Category] when required.

So let's say [Category] = 'Apple'

The trigger filters the list, and it shows :

> Available (White) items : 'Red'; 'Green'; 'Pink'

> Unavailable (Grey) : 'Blue'; 'Black'; 'White'

That all works well, but ....

If a user now selects [Option] 'Red' ; then ALL other options become grey.

There is no longer a distinction between those that are

and

Is there a solution for this ?

Ideally I'd like to display ONLY the options available after filtering [Category]

and of the remaning; behave like a normal list.

Anil_Babu_Samineni — Tue, 20 Jun 2017 10:39:27 GMT

I read and i may help you regarding this if i understand currently. Can you try this for your list box. I am sorry, If i miss understand your isue

Aggr(FieldName, FieldName)

avinashelite — Tue, 20 Jun 2017 11:01:50 GMT

how is your data association ? and how your setting the triggers ?

I think your Category; Option are in same inline table and hence only associated values are showing ...

share the sample app will help you out