Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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

View solution in original post

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.

Partner
Partner

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.)

Partner
Partner

It will match all the RegionNames starting with Dummy.

E.g Dummy1245

Dummyjkdfdfn

Dummy8fjf7

dummy04949

dummydlfd

DUMMYdkfdf

dUMMYnfksdf

All are accepted