Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Showing results for 
Search instead for 
Did you mean: 
nagarjuna9629
Contributor II
Contributor II

set analysis

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

Labels (1)
12 Replies
tresB
Champion III
Champion III

@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.

ManuelRühl
Partner - Specialist
Partner - Specialist

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.

Manuel Rühl
tresB
Champion III
Champion III

Thanks, red/blue corrected. Using double quotes is fine, except for the fact 'single quotes literal match would be faster than  double quote search'.