Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
naishaansh
Contributor III
Contributor III

Single inverted apostrophe showing '

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 ? 

Labels (2)
1 Reply
avkeep01
Partner - Specialist
Partner - Specialist

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>;