topic Set Analysis NOT LIKE in QlikView

Set Analysis NOT LIKE

Thu, 09 Jan 2014 17:45:36 GMT

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

Re: Set Analysis NOT LIKE

jaimeaguilar — Thu, 09 Jan 2014 17:50:09 GMT

this

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

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

regards

Re: Set Analysis NOT LIKE

Thu, 09 Jan 2014 18:01:12 GMT

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.

Re: Set Analysis NOT LIKE

jaimeaguilar — Thu, 09 Jan 2014 18:17:29 GMT

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

Re: Set Analysis NOT LIKE

Thu, 09 Jan 2014 18:21:05 GMT

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.