Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

listbox: values possible to select

Hi,

Generally QlikView marks values impossible to selects in a listbox by a grey colour.

So there are white values possible to select and grey values.

I don't need values to become grey on condition they are not possible to select.

So how can I tune a listbox so that it could display all values not making some of them grey?

Thank you in advance,

Larisa

11 Replies
Anonymous
Not applicable
Author

Thanks, everyone, for your comments!

I'll try your advice a bit later.

Anonymous
Not applicable
Author

Hi,

I tried this approach. But it doesn't seem work the way I need.

E.g. there are 24 months in my data, but brand 'BYD' is available on 3 months only.

Step1: I set =aggr(only({<Brand = $::Brand,Month = $::Month>} Month),Month) for check box Month.

Step2: I select brand 'BYD'.

Step3: I see only 3 months available in check box Month. Others disappeared.


My task is not to let Months disappear. They all must be present.

For some reasons Brand and Month must have the same alternate state.


Please see the file attached.


Is there any solution?