Set Analysis

[vanderson009]

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.

[ecolomer]

Can you try:

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

[tresesco · Accepted solution]

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 )