Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

populating listbox with expression, ignoring values

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!

0 Replies