Expression

[deepakqlikview_123]

Hello All,

Can you please tell me how below expression will work.

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

Thanks,

[#2 · Accepted solution]

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]

Hello,

You can use in script

Where WildMatch(RegionName,'Dummy*')

It will load data for RegionName starting with Dummy

[#4]

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]

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]

It will match all the RegionNames starting with Dummy.

E.g Dummy1245

Dummyjkdfdfn

Dummy8fjf7

dummy04949

dummydlfd

DUMMYdkfdf

dUMMYnfksdf

All are accepted