populating listbox with expression, ignoring values

Anonymous — Fri, 26 Jan 2018 21:47:31 GMT

I'm creating a list box from an expression that I'd like to be populated with the same values regardless of the selection. Somehow the set analysis qualifier {1} doesn't work.

=aggr(

//minstring({1<Role={"*"}>}

if(sum({1}TeamAllocation*ClientAllocation)>0,Role)

//)

,Role)

I tried using minstring as replacement for only(...) suggested elsewhere.

Any recommendations? Thanks!

topic populating listbox with expression, ignoring values in QlikView

populating listbox with expression, ignoring values