Using special characters in Calculated Dimension in QLikView

[#1]

I have a Calculated Dimension in a Pivot Table with some characters which may be interpreted as special characters. I suspect that this is the cause for the 'error in calculated dimension' which i get.

Characters include '/', '.', '&', '(', ')'. Which characters are indeed special characters, and how to make them been considered as normal characters ?

Thanks in advance

[alexandros17]

Use chr(nnn) for special carachers

[#3]

thanks. that is to say chr(\), chr(&), etc... ?

[#4]

Additionally, there is a quote character ' inside a string. How to make it considered as a character in the string ?

thanks in advance

[its_anandrjs]

Use CHR() function in the calculated dimension

Ex:-

Chr(92) and Chr(38) in the calculated expression

[shane_spencer]

Have a look at this example using CHR(39) instead of '

[#7]

do i simply replace in the string the character by chr(xx) or what is the syntax ?

Thanks for your help

[shane_spencer]

Replace the special character such as ' with the corresponding CHR() i.e. CHR(39) is equal to '

[its_anandrjs]

Use Replace function with the Chr() function and use that Chr value to replace

[#10]

I cannot open the file in the Personal Edition. Would you accept to reproduce the expression here ?

Thanks