Qlik Community

Ask a Question

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
Showing results for 
Search instead for 
Did you mean: 
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

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

Contributor III
Contributor III

Thanks sunny it works

No problem

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