Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. $300 savings extended to February 9th Learn More
Highlighted
jgarciaf106
New Contributor III

WildMatch Grouping

Hi Experts,

I am Wondering if this is possible or if any suggestions I could have to accomplish the following:

I have the following Countries which I need to Group into Clusters:

Argentina  And Uruguay should by Group as Arg + Uru

Costa Rica ,Barbados ,Bahamas ,El Salvador ,Guatemala    ,Honduras    Jamaica      Group as Caricam                     

Chile  ,Colombia  ,Ecuador ,Peru, Venezuela Group as Pacific


I achieved that by using Wildmatch, but I am Wondering if its possible to create an additional group that holds all countries mentioned into a new group named Latam.


I attempted with Wildmatch and did not Work


Any Suggestion?



Thanks,

2 Replies
CarlosAMonroy
Contributor III

Re: WildMatch Grouping

Hi Andres,

I guess you have to create either an other field to add that group or duplicate data and have it in the same field.

Carlos

Partner
Partner

Re: WildMatch Grouping

Does this work?

CountryTable:

Load * Inline [

COUNTRY, ADDITIONAL GROUP, GROUP

Argentina, Latam, Arg + Uru

Uruguay, Latam, Arg + Uru

Costa Rica,Latam, Caricam

Barbados,Latam, Caricam

Bahamas,Latam, Caricam

El Salvador,Latam, Caricam

Guatemala,Latam, Caricam

Honduras,Latam, Caricam

Jamaica, Latam, Caricam                   

Chile,Latam, Pacific

Colombia,Latam, Pacific

Ecuador,Latam, Pacific

Peru,Latam, Pacific

Venezuela,Latam, Pacific

];