topic Expression in QlikView

Expression

deepakqlikview_123 — Tue, 01 Apr 2014 07:05:03 GMT

Hello All,

Can you please tell me how below expression will work.

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

Thanks,

Re: Expression

Tue, 01 Apr 2014 07:19:00 GMT

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

Re: Expression

mangalsk — Tue, 01 Apr 2014 07:21:34 GMT

Hello,

You can use in script

Where WildMatch(RegionName,'Dummy*')

It will load data for RegionName starting with Dummy

Re: Expression

Tue, 01 Apr 2014 07:22:53 GMT

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.

Re: Expression

kangaroomac — Tue, 01 Apr 2014 07:34:49 GMT

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

Re: Expression

brijesh1991 — Tue, 01 Apr 2014 07:49:09 GMT

It will match all the RegionNames starting with Dummy.

E.g Dummy1245

Dummyjkdfdfn

Dummy8fjf7

dummy04949

dummydlfd

DUMMYdkfdf

dUMMYnfksdf

All are accepted