List Box Issue

[rahulsingh12]

I have two ID columns namely A and B

In A I have some values of B also.

In list box I want only those A's value that are not in B

When I write ONLY({<A-=p(B)>} A)  the list box comes as empty?

Any reason for this?

Regards,

[tresesco · Accepted solution]

Try like:

Aggr(ONLY({<A-=p(B)>} A)  , A)

[Kushal_Chawda]

Aggr(ONLY({<A=e({1}B)>} A)  , A)

[rahulsingh12]

It is working fine but the only issue is that I am not able to search anything in the listbox

[avinashelite]

When you add expression to the list box the direct search option will not work enable the wildcard search option or try to derive the same in the script level that will work

[ahaahaaha]