topic List Box Issue in QlikView

List Box Issue

rahulsingh12 — Tue, 27 Jun 2017 09:05:32 GMT

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,

Re: List Box Issue

tresB — Tue, 27 Jun 2017 09:09:52 GMT

Try like:

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

Re: List Box Issue

Kushal_Chawda — Tue, 27 Jun 2017 09:12:33 GMT

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

Re: List Box Issue

rahulsingh12 — Tue, 27 Jun 2017 09:25:14 GMT

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

Re: List Box Issue

avinashelite — Tue, 27 Jun 2017 09:29:09 GMT

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

Re: List Box Issue

ahaahaaha — Tue, 27 Jun 2017 09:33:11 GMT