Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

escape character in qilkview expression

I have expression that is like

=Replace([FIN-AP-Company Code Country Text],'Cote d'Ivoire','Ivory Coast')

since Cote d'Ivoire is having ' it is giving error in the expression, I wonder if there is any excape character in qlikview

3 Replies
Highlighted

Try this may be:

=Replace([FIN-AP-Company Code Country Text],'Cote d''Ivoire','Ivory Coast')

Notice the two single quotes. Look for escape sequence here : Escape sequences

Highlighted
Contributor III
Contributor III

Thanks sunny it works

Highlighted

No problem

I also very recently learned about this. So I am glad I was able to share it with someone else.

Best,

Sunny