topic Regarding Apostrophe in QlikView

Regarding Apostrophe

Fri, 29 Mar 2013 14:31:48 GMT

Hi All

i need to pass in condition this statement

If( Status = 'Doesn't want to go', 'Doesnot want to go')

the "apostrophe" in the word "Doesn't " is not allowing to pass the complete statement

how can that be solved.

Re: Regarding Apostrophe

alexandros17 — Fri, 29 Mar 2013 15:02:50 GMT

try with

=if(Status='Doesn' & chr(39) & 'want to go','SI','NO')

Re: Regarding Apostrophe

stevedark — Fri, 29 Mar 2013 15:38:06 GMT

The concatenate of the chr(39) character works fine, but if you have many apostrophes you may want to go for:

if(Status=replace('Doesn¬t want to ¬go¬', chr(39)), 'Does not want to go')

You just need to manually swap out any apostrophes out for a character you don't use anywhere else and then swap it back in with the replace statement.

Hope that helps,

Steve

http://www.quickintelligence.co.uk/