topic Re: set analysis in QlikView

set analysis

nagarjuna9629 — Mon, 26 Jan 2026 18:19:17 GMT

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

Re: set analysis

tresB — Tue, 26 Oct 2021 05:37:59 GMT

Try like:

sum({<categoryname={'men''swear'>}unitprice)

Re: set analysis

ManuelRühl — Tue, 26 Oct 2021 05:39:32 GMT

Hi @nagarjuna9629 ,

I think there are a brace and quotation marks missing: =sum({<categoryname={"men'swear"}>}unitprice)

Re: set analysis

nagarjuna9629 — Tue, 26 Oct 2021 05:53:24 GMT

its not working

Re: set analysis

nagarjuna9629 — Tue, 26 Oct 2021 05:54:02 GMT

it's working sir

Re: set analysis

tresB — Tue, 26 Oct 2021 05:56:32 GMT

@nagarjuna9629 , please ensure that you use two single quotes in the middle and not a double quote - then it would work.

Re: set analysis

ManuelRühl — Tue, 26 Oct 2021 06:03:16 GMT

Thanks. Please tag my answer as correct, so others can benefit from this thread as well.

@tresB I think it is not men AND swear but men's wear like men's clothes

Re: set analysis

nagarjuna9629 — Tue, 26 Oct 2021 06:03:57 GMT

i was tried that one also...but result shows 0

Re: set analysis

tresB — Tue, 26 Oct 2021 06:27:34 GMT

@nagarjuna9629 , @ManuelRühl , it works with me. And I am sure, it should work with you as well, if you are not mixing up the single and double quote that I mentioned above (i.e. - the two single quotes and not double quote).

Re: set analysis

ManuelRühl — Tue, 26 Oct 2021 06:37:12 GMT

you're right, it works. But I don't know why 🙈

I always use double quotes...

Re: set analysis

tresB — Tue, 26 Oct 2021 08:40:08 GMT

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

Re: set analysis

ManuelRühl — Tue, 26 Oct 2021 07:08:15 GMT

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.

Re: set analysis

tresB — Tue, 26 Oct 2021 08:43:13 GMT

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