I am limiting a list box, but it is causing the current selection to pick up the limiting factor, how do I get rid of that

[laureadiaz]

Hello,

   I am limiting a list box with the following expression,

=IF(Qty_1>'0',Short_ID) 

  The List box is limiting the Short_ID's that have a Qty_1, but now, when I select something with that List Box it also selects Qty_1.

   How do I just get it to select the Short_ID and not Qty_1?


Thanks!

[sunny_talwar · Accepted solution]

Try this

Aggr(Only({<Qty_1 = {'>0'}>} Short_ID), Short_ID)

[laureadiaz]

Thanks these worked!