topic Re: Simple quote in a field in QlikView

Simple quote in a field

Mon, 07 Jan 2013 15:58:38 GMT

I have a field which have a quote as :

- String's

- J'aime

How can I handle this in expression like sum( If ( FIELD = ' my string value' , NumField))

Any idea

shree909 — Mon, 07 Jan 2013 16:01:48 GMT

i am not sure

try this

sum( If ( FIELD = '[ my string value]' , NumField))

Mon, 07 Jan 2013 16:14:36 GMT

Thanks but it doesnt' work !

adamwilson — Mon, 07 Jan 2013 16:30:53 GMT

try this:

sum( If ( FIELD = 'J' & chr(39) & 'aime' , NumField))

instead of " J'aime "

The Chr(39) substitutes the ' character.

nagaiank — Mon, 07 Jan 2013 16:32:50 GMT

Try

sum( If ( FIELD = 'String' & Chr(39) &'s' , NumField))

Mon, 07 Jan 2013 16:41:51 GMT

Thanks guys it works like a charm !