it's works as expected.
take a look here Right - script and chart function ‒ QlikView
it's just another field created on the fly.
you also do the same in script as below:
If(Right(Region,7)='America','Americas','EMEA') as NewRegion
and use this new field as your chart dimension.
Hey and thanks for everyone's replies. As they are all correct I will mark the first one, it also being most easy to understand.
Ok so If(Right(Region,7)='America','Americas','EMEA') is just an 'if' statement. I was looking at it wrong because I was driven off by the use of 'Right' string in it.
So this is how I now understand it: If (the string of last 7 = "America") then ("Americas") else ("EMEA").