How to make a selective SUM (multiple columns) for a chart

[alejnadro]

Hello everyone!

I´m new at qlik so my questions may be very basic, but I guess we all started somehow similar   and iw worse not to ask.

I have a table similar to this:

If I want to sum the entire Value column I use:

Sum(Value)

(expected result: 254)

If I want to sum Value for the Month 1 I use:

Sum({<Month={1}>}Value)

(expected result: 102)

But, how do I sum Value for the Month 1 AND Broker BA ? 

(expected result: 62)

And how would it be to sum Value for month 1 AND Broker BA AND Stock A ?

(expected result: 10)

THANK YOU SO MUCH IN ADVANCE!

PS: Im using qlik sense cloud

[siddharth_s3 · Accepted solution]

Hey Alejandro,

This is what you need for your 1st and 2nd respectively:

Sum({<Month={1}, Broker={'BA'}>}Value)
Sum({<Month={1}, Broker={'BA'},Stock={'A'}>}Value)