Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
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>;