Hide grayed out data from List box when a value is selected

[alec1982]

Hello,

I am not sure if there is another way of doing this beside the below but would love to get opinions..

I need to hide grayed out data when a value in a list box is checked..

The only way so far is by going into the list box option and check hide excluded..

Any other suggestions?

Thxs,

Alec

[rustyfishbones]

try

AGGR(Address,Address)

does the same as the suggestions above, but much easier to remember

Thanks

Alan

[agilos_mla · Accepted solution]

Then,

You've had to disable the address selection in the set analysis.

=aggr(Concat(DISTINCT {<Client=P(Client), Address=>} Address), Address)

[rustyfishbones]

Is there a need for that?, I don't think there is

[#5]

Alan - why would I want something simple when something complicated/long works just as well? Thanks Alan!

[rustyfishbones]

I mean this in the nicest possible way, but you sound like my wife

it's good to know a few ways though!

[rustyfishbones]

BTW

Love your Qlikview Design Blog http://intuiqlik.com/

[alec1982]

Thanks all for your help!

[rbecher]

..or

=Aggr(Only(Address), Address)

This gives you the possibility to use an additional set analysis in Only() if needed.

- Ralf

[rbecher]

I think Concat will be really slow on a big data set..

[rustyfishbones]

Thanks Ralf,

I will remember that tip