Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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.
markgraham123
Contributor II

Where statement with Match, not match, and not Wildmatch

Hi Everyone,

I'm trying on the Where statement below: But getting an error ") Expected"

(Name='ABC' and Match(Department,'B') and  not WildMatch(Region, B*, C*, D*, F*, H*, J*, L*, M*, O*, P*, Q*, R*) and not Match(Region, SBB, STS, UPU, PSI))


fetch the details of ABC, where department is B.

Donot include the regions starting with B, C, D, F, H, J, L, M, O, P, Q, R.

Donot include the regions SBB, STS, UPU, PSI.


Please lemme know whether i'm on the right track.


Help pls.







1 Solution

Accepted Solutions
Employee
Employee

Re: Where statement with Match, not match, and not Wildmatch

You need to put B* in single quotes. (And all other strings you want to compare with.)

HIC

4 Replies
Employee
Employee

Re: Where statement with Match, not match, and not Wildmatch

You need to put B* in single quotes. (And all other strings you want to compare with.)

HIC

Re: Where statement with Match, not match, and not Wildmatch

This is what Henric‌ means

Where (Name='ABC' and Match(Department, 'B') and not WildMatch(Region, 'B*', 'C*', 'D*', 'F*', 'H*', 'J*', 'L*', 'M*', 'O*', 'P*', 'Q*', 'R*') and not Match(Region, 'SBB', 'STS', 'UPU', 'PSI'))

markgraham123
Contributor II

Re: Where statement with Match, not match, and not Wildmatch

Thanq Henric.Smiley Happy

markgraham123
Contributor II

Re: Where statement with Match, not match, and not Wildmatch

Thanq Sunny.

Happy that You're back.

Community Browser