filter has to be avoided in the list box

[manoranjan_d]

=aggr(only({<dept=>}name),name)

this is not working fine in the list box expression which is not excluding the dept

[sunny_talwar]

So you mean that if something is selected in dept, name should not be filtered out? To do this, you would need to use an alternate state. I don't think this will work here

[kumarkp412]

Hi Manoranjan,

can you elaborate your question please or sample  ?

Thanks

Kumar kvp

[manoranjan_d]

so this expression will not work?

only by alternate state only it ll work?

[sunny_talwar]

If what I described above is what you want, then I don't think it will work without alternate state

[kaushiknsolanki]

Hi,

Can you explain your problem with example and possibly sample data.

Regards,

Kaushik Solanki