how to handle with quote inside an expression?

[#1]

Hi,

i'm just trying some qlikview excercises but when in my example i have a category name with a quote in it, so when i use it in an expression it doesn't work cause you have to set the name also between quotes... this is my example:

sum({$<CategoryName={'Children's Clothes'}, Office={4}>} LineSalesAmount)

is there an easy way to fix this?

thx

[deepakk]

HI

try Double Quotes

sum({$<CategoryName={"Children's Clothes"}, Office={4}>} LineSalesAmount)

[prieper]

use CHR(39) instead ('Children' & CHR(39) & ' Clothes'),
if not working, you may need to build a variable first (LET sCategory = 'Children' & CHR(39) & ' Clothes';)

HTH
Peter