Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
Showing results for 
Search instead for 
Did you mean: 

ListBox filtering

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

  • available for [Category] Apple, but not selected


  • those that are NOT available for Apple at all.

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.

2 Replies

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)

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

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