topic Wildcards within an IF statement in a Script in QlikView

Wildcards within an IF statement in a Script

Anonymous — Wed, 18 May 2016 19:16:36 GMT

Hi everyone,

I multiple IF statements for data scrubbing purposes. I've tested one but when I use a wildcard it just doesn't work. It seems to ignore it or it tries to literally search for the asterisk within the field data. I also tried % character for a wildcard. No luck.

If ([Make] = 'Mercedes', 'Mercedes Benz', [Make])

If ([Make] = 'Mercedes*', 'Mercedes Benz', [Make]) (doesn't work)

Re: Wildcards within an IF statement in a Script

Wed, 18 May 2016 19:45:04 GMT

Hi Brian,

Try If(Wildmatch([Make],'Mercedes*')=1,'Mercedes Benz',[Make])

You can read more about Wildmatch function in reference manual or QlikView Help.

BR,

Milosz

Re: Wildcards within an IF statement in a Script

alexpanjhc — Wed, 18 May 2016 19:46:50 GMT

if (wildmatch([Make] , 'Mercedes*')>0,'Mercedes Benz', [Make])

Re: Wildcards within an IF statement in a Script

sunny_talwar — Wed, 18 May 2016 20:26:04 GMT

Or this:

If(Index(Make, 'Mercedes'), 'Mercedes Benz', Make)

Re: Wildcards within an IF statement in a Script

holmlund — Wed, 18 May 2016 21:05:08 GMT

If(Make like '*Mercedes*', Make)

Re: Wildcards within an IF statement in a Script

MarcoWedel — Wed, 18 May 2016 21:21:11 GMT

If ([Make] like 'Mercedes*', 'Mercedes Benz', [Make])

Re: Wildcards within an IF statement in a Script

MarcoWedel — Wed, 18 May 2016 21:26:42 GMT

Hi,

maybe also helpful:

if condition

regards

Marco

Re: Wildcards within an IF statement in a Script

Anonymous — Wed, 18 May 2016 21:42:19 GMT

Thank you very much everyone for the WILDMATCH function and the INDEX. I just looked them up in the reference. Wildmatch says it is case sensitive. Sunny do you know if the same is so for Index?

Re: Wildcards within an IF statement in a Script

sunny_talwar — Wed, 18 May 2016 22:20:54 GMT

I think Index is case sensitive as well. To get around this, you can use Upper() or Lower() functions:

If(Index(Lower(Make), 'mercedes'), 'Mercedes Benz', Make)

Re: Wildcards within an IF statement in a Script

MarcoWedel — Wed, 18 May 2016 22:59:29 GMT

WildMatch() and like both are case insensitive.

wildmatch ‒ QlikView

regards

Marco

Re: Wildcards within an IF statement in a Script

Tue, 14 Jun 2016 11:59:32 GMT

How about:

IF(SUBSTRINGCOUNT(UPPER(MAKE),'MERCEDES') > 0, 'Mercedes Benz', Make) AS ...