Single inverted apostrophe showing '

[naishaansh]

I have a country titled People's Republic of China in the database and it shows in Qlik in the table as People's Republic of China . The inverted apostrophe is encoded as HTML character.

1. How do I fix this to shows People's ?

2) Why is it causing in Qlik ? 

[avkeep01]

Hi, 

you can create an inline table with the description of the characters. 

MAP_Characters:
MAPPING LOAD * INLINE [
Code, Character
', "'"
];

Table:
LOAD 
MAPSUBSTRING('MAP_Characters',Country) AS Country
FROM <table>;