Change name of a region for map visualization

[nbuscemi]

Hi,

I need to create a map. In my data source some regions are written wrongly, for example 'Emilia Romagna' has to be written with a dash ('Emilia-Romagna'). Is there a way to change the region's name? Or is there a way to geolocalize the region?

Thanks.

[nbuscemi]

I cannot access the tables view either modify the data loaded. I'm working on the desktop version, importing the apps as qvf one of my colleagues loaded on qlik server.

[nbuscemi · Accepted solution]

Solution found! 

Simply put if function into the script right after the field you are interested to modify.

Example:

LOAD
COUNTRY,
REGION,
if(REGION='EMILIA ROMAGNA', 'EMILIA-ROMAGNA', REGION) as REGION2,
PROVINCE,
...