Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
DR1
Contributor

sum if

Hi,

I want to select a category and see the sum of a certain category for example like this

Sum(OrderMargin If([SuperStore Sales - Customers.CustomerSegment]='Consumer'))

Im new to qlik sense so Im not sure how i should make this work.

Labels (2)
1 Reply
vinieme12
Champion III

As below

Sum({<[Customers.CustomerSegment]={'Consumer'}>}OrderMargin)

 

Learn more on set analysis here 

https://www.analyticsvidhya.com/blog/2014/01/set-analysis-qlikview/

 

 

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