Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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

1 Solution

Accepted Solutions
Highlighted
Champion III
Champion III

did u try with single or double quotes?

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

View solution in original post

10 Replies
Highlighted
Champion III
Champion III

did u try with single or double quotes?

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

View solution in original post

Highlighted
Champion III
Champion III

Highlighted
MVP
MVP

May be a simpler one, like:

=If(Not Match([name], 'John', 'Alan'), [name])

Highlighted

As proposed by Chanty, you need to use single quotes around the names,

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

Highlighted
MVP
MVP

=aggr(If(Not Match([name], 'John', 'Alan'), [name]),[name])

Highlighted
MVP
MVP

@ Tamil,

No, it's not like that, I believe. It should work even without quotes since the values are not having spaces in between. Hence, the expression:

=aggr(only({<[name]-={John, Alan}>}[name]),[name])  should work fine as well.

Highlighted

Hi Tresesco,

I agree. If there are no spaces in between the names, we can directly mention the names. Then why the same is not working in this case.? Any guess.?

Thanks.

Highlighted
MVP
MVP

Without looking at the representative qvw, it would be blind guesses.

Highlighted

. Just to be on the safe side, I always use single ( sometimes double ) quotes.

@matthewp  If possible, please post your QVW application.