topic Single Quote in Editor in QlikView

Single Quote in Editor

Anonymous — Wed, 19 May 2010 13:54:52 GMT

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.

Single Quote in Editor

Wed, 19 May 2010 13:58:20 GMT

Try it with the a

Single Quote in Editor

Wed, 19 May 2010 13:59:45 GMT

Try it with the ascii value for a single quote:

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

Regards,

Gordon