Qlik Community

Ask a Question

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Do More with Qlik - for Beginners and Beyond, Topic: Qlik Replicate on January 21, 2PM EST. REGISTER NOW
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.