# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. Register by February 29th to save \$200. Learn More
Highlighted
New Contributor II

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

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

Tags (3)
1 Solution

Accepted Solutions
Partner

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

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)
```
```Sum({<Month={1}, Broker={'BA'}>}Value)