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

[alec1982]

In other way assuming I have two list boxes One called Client and one called address

If I select Client A from Client then all addresses related to other client will be grayed out..

Is there anything i could use within the expression of the list box to show data where client = getfieldselections value of Clients equal the selected client?

[#3]

You could use an expression in the list box, but I am not sure how well it would perform on very large data sets.  Try something like:

=if(Aggr(FindOneOf(YourAddressField,Concat(Chr(39) & YourAddressField & Chr(39),', ')),YourAddressField)=1,YourAddressField)

This way onle the related items will show in white; nothing will show in gray.

[alec1982]

Hi Rebecca,

Thank you for your help but it doesn't work. the expression returned only 1170 value while the total values should be 1176.

Thxs,

Alec

[#5]

Hmm.  Do you have some sample data?  It works for me.

[agilos_mla]

Hi Badr,

You can simply try this in the list box expression :

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

KR,

Michael

[alec1982]

this works exactly as the hide excluded on the list box option..

I need the values to be hidden based on the client name same to what we do set analysis expression and we enter the client name..

Thxs,

Alec

[#8]

Guess I don't understand what you're looking for then.  If you have an example, we can probably help.

[alec1982]

Both of the expression are correct but they both work similar to hide excluded check box.

The problem is if I apply the expression and then filter the clients on Client A it will show its related addresses in the address list box then If i filter on one of the addresses the other addresses will be hidden. while I need to hide the data based on the client name then when I apply other filters the unrelated data will be grayed out..

Hope that explain it..

Thxs,

Alec 

[rustyfishbones]

Hi Rebecca,

you don't need the long expression

try

AGGR(Address,Address)

it works fine