Create a Regional View

[gfisch13]

Hi - I have a Location field in my initial table that includes about 50 different countries.  I'd like to group those locations into 3 Regions - Americas, Asia, EMEA.   I tried using various expressions but I'm not getting anywhere close.  The more I read, it appears that I should do this in the script??  Can anyone offer a best practice or something easy to replicate???

Thanks, George

[swuehl]

As I tried to explain earlier, you can use LIKE operator (or WildMatch() function) to create a condition for record filtering:

LOAD

     MoneyRecord

FROM ...

WHERE MoneyRecord LIKE '*USD';

or

...

WHERE WildMatch(MoneyRecord, '*USD');

or

...

WHERE RIGHT(MoneyRecord, 3) = 'USD';

Or maybe also

...

WHERE SUBFIELD(MoneyRecord,' ',-1) = 'USD';

[gfisch13]

Thank you to both of you for your help.  I'm new to Qlikview so just trying to understand where everything goes.   This was a big help and learning experience.