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

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
matthewp
Creator III
Creator III

aggr only more than one value excluded in list box

I have a list box that is powered by an expression to hide 1 value.

=aggr(only({<[name]-={John}>}[name]),[name])

but i want to add a second name to this. I have tried...

=aggr(only({<[name]-={John, Alan}>}[name]),[name])


and


=aggr(only({<[name]-={John}, {Alan}>}[name]),[name])


With no luck

10 Replies
Not applicable

Hi,

Try this =aggr(only({<[name]-={'John','Alan'}>}[name]),[name])