Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Highlighted
markgraham123
Valued Contributor

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

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

View solution in original post

4 Replies

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

View solution in original post

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
Valued Contributor

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

Thanq Henric.:)

markgraham123
Valued Contributor

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

Thanq Sunny.

Happy that You're back.