Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
did u try with single or double quotes?
=aggr(only({<[name]-={'John', 'Alan'}>}[name]),[name])
did u try with single or double quotes?
=aggr(only({<[name]-={'John', 'Alan'}>}[name]),[name])
May be a simpler one, like:
=If(Not Match([name], 'John', 'Alan'), [name])
As proposed by Chanty, you need to use single quotes around the names,
=aggr(only({<[name]-={'John', 'Alan'}>}[name]),[name])
=aggr(If(Not Match([name], 'John', 'Alan'), [name]),[name])
@ 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.
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.
Without looking at the representative qvw, it would be blind guesses.
. Just to be on the safe side, I always use single ( sometimes double ) quotes.
@matthewp If possible, please post your QVW application.