topic Re: Set Analysis in QlikView

Set Analysis

vanderson009 — Wed, 27 Aug 2014 05:53:54 GMT

Hi guys,

Why this set analysis is not working

sum( {$<Customer = P({1<Product={‘Shoe’}>} Customer)>} Sales )

i want sales of customer who having bought product only as Shoe.

is there any problem with my Qvw application.

- Thanks

Villyee.

Re: Set Analysis

ecolomer — Wed, 27 Aug 2014 06:04:34 GMT

Can you try:

Sum({<Product={'Shoe'}>} Sales)

Re: Set Analysis

tresB — Wed, 27 Aug 2014 06:06:30 GMT

Probably you have copied this expression from help/manual. There the single quotes are some other character. That cuases the issue. Delete those copied quotes and type your quotes, it will work.

sum( {$<Customer = P({1<Product={'Shoe'}>} Customer)>} Sales )Customer)>} Sales )