Discussion board where members can get started with Qlik Sense.
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
I guess you have to create either an other field to add that group or duplicate data and have it in the same field.
Does this work?
Load * Inline [
COUNTRY, ADDITIONAL GROUP, GROUP
Argentina, Latam, Arg + Uru
Uruguay, Latam, Arg + Uru
Costa Rica,Latam, Caricam
El Salvador,Latam, Caricam
Jamaica, Latam, Caricam