sum if

[DR1]

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.

[vinieme12]

As below

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

Learn more on set analysis here 

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