How to include a single quote (') within a String?

[aslam24196]

Hey,

So suppose I wanted to have this Set Expression where I want to Calculate the Sales in the country, Cote D'Ivorie

I used

Sum ( { $< Country = { 'Cote D'Ivore'} >} Sales).

But the problem is The String ends after it reads the ( ' ) after the D in the country name.

What is the workaround for this?

[rwunderlich]

Code the single quote twice.

Sum ( { $< Country = { 'Cote D''Ivore'} >} Sales)

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

[sunny_talwar · Accepted solution]

You can read more about what Rob has suggested here

Escape sequences