Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikview979
Specialist
Specialist

Set Expression

Hi Experts,

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

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

17 Replies
qlikview979
Specialist
Specialist
Author

Not working

qlikview979
Specialist
Specialist
Author

Hi Bro,

  

ProductCustomer                   sales
LaptopMadhu50000
LaptopRavi70000
LaptopRaja1000000
ShoesMadhu1500
ShoesRaja4200
ShoesKrishna45000
T.VMadhu25000
T.VRavi27000
T.VRaja32000
W.MRaja1500
W.MMadhu8000
W.MRavi15000
qlikview979
Specialist
Specialist
Author

Here i want to eliminate sales when product sheos  sales <=1500

antoniotiman
Master III
Master III

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

enfodavid
Partner - Contributor III
Partner - Contributor III

What are you trying to achieve mahesh? Walk us through it in words.

For example your first one I would explain as this:

Take all sales and take all sales for shoes that for each transaction that are above 1500. (So I would say a logical fault here, maybe you want to discard all sales that are below 1500 for shoes?)

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


Is this what you are after?


Anonymous
Not applicable

SUM({<Product={'Shoes'},Sales={'>1500'}>} Sales)+SUM({<Product={'*'}-{'Shoes'}>} Sales)

vinieme12
Champion III
Champion III

then this

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

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Frank_Hartmann
Master II
Master II

have a deeper look at sunnys solution.

for me its working with the data you provided.