Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
In set analysis,
category names& unit price:
sportswear-500
men's clothes-880
women's clothes-900
the value of
=sum({<categoryname={men'swear>}unitprice)
shows zero
wher i did mistake?plz find my mistake
@ManuelRühl , let me explain 'why'. I don't want to give the impression that it just works, the fact is it works as expected.
Explanation : your string is men's wear. In set analysis, if you use literal search, you include the string within single quotes. That means, it would look something like : 'men's wear' , but then qlik engine gets confused with the closing single quote and the string part apostrophe, so we have to use an escape sequence. There are many options for escape characters here but we are using the single quote. That is, when I write 'men''s wear', then the first (red) single quote is escape sequence; telling qlik engine to not consider the following (blue) single quote as special character to close the string but treat as a part of the string.
Thanks for the explanation.
red and blue are mixed up I think. 🤔
But why not just simply use "men's wear" with the double quotes?
Double quotes normally do not occur within text-dimensions.
Thanks, red/blue corrected. Using double quotes is fine, except for the fact 'single quotes literal match would be faster than double quote search'.