topic Re: wildcard matching within if statement in QlikView

wildcard matching within if statement

Wed, 29 Jan 2014 10:57:16 GMT

Hi everyone,

today, Im having simple problem that is driving me crazy!

All I want to do is to evaluate if supplyed text matches an expression and then do something:

Let maskedCount = 1;

LET name = 'BRR_wrwq';

if Match($(name), '*BRR_*') then

let maskedCount = $(maskedCount) + 1;

ENDIF

I have tried all of if and *Match functions in perhaps all combinations possible but its doing just what it wants 😕

In this particular case Im referring to wildmatch function

It still skips the let statement and if I add <>0 it allways enters it

Im using QlikView 11 SR1 64bit

Thank for your responses!

jonathandienst — Wed, 29 Jan 2014 11:24:19 GMT

This should work:

Let name = 'BRR_wrwq';

If WildMatch('$(name)', '*BRR_*') then

Let maskedCount = maskedCount + 1;

End If

Let name = 'BRR_wrwq';

Let maskedCount = maskedCount + If(WildMatch('$(name)', '*BRR_*'), 1, 0);

HTH

Jonathan

juleshartley — Wed, 29 Jan 2014 11:29:20 GMT

You need to enclose the variable in apostrophes, and use 'wildmatch'

...if wildmatch('$(name)','*BRR_*') then ...

Wed, 29 Jan 2014 11:30:44 GMT

both you solutions are working, thank you very much!
Mystery solved!