Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

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

Single Quote in Editor

I have to put a condition on text which itself contains a single quote. IF(column='Text's',true,false). How do I accomplish that? I tried enclosing single quote with double quote, but it did not work. Any idea?

Thanks,

Dinesh.

1 Solution

Accepted Solutions
Highlighted
Not applicable

Try it with the ascii value for a single quote:

if (column= 'text' & chr(39) & 's', true, false)

Regards,

Gordon

View solution in original post

2 Replies
Highlighted
Not applicable

Try it with the a

Highlighted
Not applicable

Try it with the ascii value for a single quote:

if (column= 'text' & chr(39) & 's', true, false)

Regards,

Gordon

View solution in original post