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

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

aslam24196 — Wed, 25 Nov 2020 16:16:04 GMT

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 — Fri, 19 Jan 2018 19:18:22 GMT

Code the single quote twice.

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

-Rob

sunny_talwar — Fri, 19 Jan 2018 20:32:05 GMT

You can read more about what Rob has suggested here