Set Analysis NOT LIKE

[#1]

I'm trying to write a Set Analysis that ignores products that begin with "DO NOT USE".

This syntax works

=SUM({<ProductDesc = {'DO NOT USE*'}>} Sales)

but not this

=SUM({<ProductDesc != {'DO NOT USE*'}>} Sales)

and I can't find an equivalent syntax similar to SQL NOT LIKE

[jaimeaguilar · Accepted solution]

hi

this

=SUM({<ProductDesc -= {'DO NOT USE*'}>} Sales)

or

=SUM({<ProductDesc = {'*'} - {'DO NOT USE*'}>} Sales)

regards

[#3]

Thanks Jamie!

I tried -= but didn't apply to all expressions in the table so those "DO NOT USE" dimension items were still displayed due to the other expressions returning a value.

I tried both syntaxes you suggested and they both worked.

[jaimeaguilar]

I prefer to use the second option, because syntax checker does not recognize this -> -= So everything you type after that will be underlined as if it was wrong, but it's not

[#5]

Agree. I implemented the second option.

The hyphen "-" throws off the syntax checker. This is an old known bug. I hope QV resolves that soon.