Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Thanks, everyone, for your comments!
I'll try your advice a bit later.
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?