topic Re: "Not Like" Equivalent or Workaround Within Set Analysis in QlikView

"Not Like" Equivalent or Workaround Within Set Analysis

Mon, 26 Jan 2026 18:19:17 GMT

Hello Qlikviewers

I have a report at the moment that I need to exclude values that have 'Serv', 'Service', 'Front' and 'Fronting' within the name from Set Analysis.

At the moment the expression I'm using is very basic

Sum(Value)

So I'm just wondering if there is a SQL NOT LIKE equivalent within set analysis that I can use to remove values that have the above within the name?

swuehl — Thu, 28 Jan 2016 19:43:07 GMT

You can look at the minus operator - in combination with search expressions for your field values:

Sum({<NameField -= {"*Serv*","*Front*"}>} Value)

p_verkooijen — Thu, 28 Jan 2016 19:46:28 GMT

Or you can create flagfields in the script, this way you can select these values using SUM{<_ValidFlag={1}>}Value)

Anonymous — Thu, 28 Jan 2016 19:47:50 GMT

Been using the Set analysis minus operator earlier today and it's saved my bacon.

p_verkooijen — Thu, 28 Jan 2016 19:51:09 GMT

HirisH_V7 — Thu, 28 Jan 2016 20:06:37 GMT

Hi,

may be like this,

sum( {$<AreaField = E({1<NameField={Serv', 'Service', 'Front' , 'Fronting' }>})>} Value )

HTH,

Hirish

Fri, 29 Jan 2016 09:03:23 GMT

Thank you my expression now looks like this

Sum({<NameField -= {'*Serv*','*Front*','*Service*','*Fronting*'}>} Value)

Hopefully this works as its supposed to

swuehl — Fri, 29 Jan 2016 12:13:40 GMT

"*Serv*" should also find the same values like "*Service*", right (and similar for Front/ Fronting)?

That's why I only used the shorter searches with wildcards.