Discussion Board for collaboration on QlikView Scripting.
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.
Go to Solution.
You need to put B* in single quotes. (And all other strings you want to compare with.)
View solution in original post
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'))
Happy that You're back.