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: 
deepakqlikview_123
Specialist
Specialist

Expression

Hello All,

Can you please tell me how below expression will work.

Where WildMatch(RegionName,'Dummy*')=0

Thanks,

1 Solution

Accepted Solutions
Not applicable

Hi,

This expression checks if the string Dummy exists in RegionName Field.

If exists it returns 1 else 0.

So basically they are filtering records with Dummy in RegionName.

* representing wild character.. i.e. the it looks for like condition. eg. Dummy, Dummy123, Dummys etc.

Thank,

Prabhu

View solution in original post

5 Replies
Not applicable

Hi,

This expression checks if the string Dummy exists in RegionName Field.

If exists it returns 1 else 0.

So basically they are filtering records with Dummy in RegionName.

* representing wild character.. i.e. the it looks for like condition. eg. Dummy, Dummy123, Dummys etc.

Thank,

Prabhu

mangalsk
Creator III
Creator III

Hello,

You can use in script

Where WildMatch(RegionName,'Dummy*')


It will load data for RegionName starting with Dummy

Not applicable

WildMatch function in QlikView is used to match the field values.

In your expression it will check that whether RegionName field matches with the 'Dummy' value, if it matches then it will show value as 0 else it will display -1.

kangaroomac
Partner - Creator II
Partner - Creator II

From the QlikView Help Menu:

"

wildmatch( str, expr1 [ , expr2,...exprN ] )

The wildmatch function performs a case insensitive comparison and permits the use of wildcard characters ( * and ?) in the comparison strings.

Example:

wildmatch( M, 'ja*','fe?','mar')

returns 1 if M = January

returns 2 if M = fex

"

So basically it works like a case insensitive IN clause in SQL allowing wildcard characters (or in pseudo terms: Does my string start with FirstVal OR equal to SecondVal OR contain ThirdVal, etc.)

brijesh1991
Partner - Specialist
Partner - Specialist

It will match all the RegionNames starting with Dummy.

E.g Dummy1245

Dummyjkdfdfn

Dummy8fjf7

dummy04949

dummydlfd

DUMMYdkfdf

dUMMYnfksdf

All are accepted