Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Wildcards within an IF statement in a Script

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)



10 Replies
Not applicable
Author

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

alexpanjhc
Specialist
Specialist

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

sunny_talwar

Or this:

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

holmlund
Contributor III
Contributor III

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

MarcoWedel

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

MarcoWedel

Hi,

maybe also helpful:

if condition

regards

Marco

Anonymous
Not applicable
Author

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?

sunny_talwar

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)

MarcoWedel

WildMatch() and like both are case insensitive.

wildmatch ‒ QlikView

regards

Marco