Set Expression

[qlikview979]

Hi Experts,

How can i write this in set expression,Here my dimension is Product

sum(if(Product='Shoes',if(sales>1500,sales),sales))

[qlikview979]

Help me on this loveisfail‌vinieme12‌avinashelite‌

Regards

[sunny_talwar]

May be this

Sum({<Product = {'Shoes'}, sales = {'>1500'}>}sales)

[Frank_Hartmann]

try like this:

sum({<Product={'Shoes'}, sales={"=sales>1500"}>} sales)

hope this helps

[sunny_talwar]

Or may be this

Sum({<Product = {'Shoes'}, sales = {'>1500'}>+<Product -= {'Shoes'}>}sales)

[qlikview979]

Hi Bro,

If condition and set expression is giving different result.

like below

[sunny_talwar · Accepted solution]

Try this

Sum({<Product = {'Shoes'}, sales = {'>1500'}>+<Product -= {'Shoes'}>}sales)

[qlikview979]

Not working what you people are provided

[vinieme12]

may be

sum({<Product={"=SUM({<Product = {'Shoes'}>}sales)>1500"} >}sales)

[vinieme12]

can you post your sample?