QlikView aggr more than one value excluded in list box

565 Views Asked by At

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])
1

There are 1 best solutions below

0
Matt On BEST ANSWER

Single quotes are required to indicate explicit values:

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