Qlik Community

QlikView Publisher

Discussion Board for collaboration on QlikView Publisher.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

"Not Like" Equivalent or Workaround Within Set Analysis

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?

1 Solution

Accepted Solutions
MVP
MVP

Re: "Not Like" Equivalent or Workaround Within Set Analysis

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

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

7 Replies
MVP
MVP

Re: "Not Like" Equivalent or Workaround Within Set Analysis

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

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

p_verkooijen
Valued Contributor

Re: "Not Like" Equivalent or Workaround Within Set Analysis

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

Also check out Set Analysis Wizard for QlikView | qlikblog.at

Re: "Not Like" Equivalent or Workaround Within Set Analysis

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

p_verkooijen
Valued Contributor

Re: "Not Like" Equivalent or Workaround Within Set Analysis

hirishv7
Honored Contributor

Re: "Not Like" Equivalent or Workaround Within Set Analysis

Hi,

may be like this,

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

HTH,

Hirish

Not applicable

Re: "Not Like" Equivalent or Workaround Within Set Analysis

Thank you my expression now looks like this

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

Hopefully this works as its supposed to

MVP
MVP

Re: "Not Like" Equivalent or Workaround Within Set Analysis

"*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.

Community Browser