topic Re: Using Wildmatch to group field values in QlikView

Using Wildmatch to group field values

stjernvd — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I am trying to group my fieldname 'Location' into 4 categories using WildMatch function, but it's not working, what am I doing wrong?

If(WildMatch(Location,'*London*','London',

if(WildMatch(Location,'*Birmingham*'),'Birmingham',

if(WildMatch(Location,'*Edinburgh*'),'Edinburgh',

If(WildMatch(Location,'*US*'),'US')))),Location) as Location

The fieldname 'Location' has the following values:

Bleak Street, London

Liverpool Street, London

Praed Street, Birmingham

Commercial Street, Birmingham

Royal Street, Edinburgh

Princes Street, Edinburgh

US Location

And I want to take the key words 'London', 'Birmingham', Edinburgh', and 'US', to group locations into 4 categories in my 'Location' fieldname.

sunny_talwar — Wed, 23 Mar 2016 11:07:03 GMT

May be this:

If(WildMatch(Location,'*London*'), 'London',

If(WildMatch(Location,'*Birmingham*'), 'Birmingham',

If(WildMatch(Location,'*Edinburgh*'), 'Edinburgh',

If(WildMatch(Location,'*US*'),'US', Location)))) as Location

Chanty4u — Wed, 23 Mar 2016 11:12:00 GMT

Gysbert_Wassenaar — Wed, 23 Mar 2016 11:13:33 GMT

If(wildmatch(Location, 'US *', 'US', subfield(Location, ',',-1)) as Location

Kushal_Chawda — Wed, 23 Mar 2016 11:16:24 GMT

another way

If(Location like '*London*', 'London',

If(Location like '*Birmingham*', 'Birmingham',

If(Location like '*Edinburgh*', 'Edinburgh',

If(Location like '*US*' ,'US', Location)))) as Location

sunny_talwar — Wed, 23 Mar 2016 11:17:23 GMT

You left a parenthesis after Edinburgh

Kushal_Chawda — Wed, 23 Mar 2016 11:21:03 GMT

Updated. It's very difficult to modify copy pasted expression

sunny_talwar — Wed, 23 Mar 2016 11:24:40 GMT

Agreed

I do that all the time