Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
HI
try Double Quotes
sum({$<CategoryName={"Children's Clothes"}, Office={4}>} LineSalesAmount)
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