# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Save \$300 - Register for QlikWorld (formerly Qonnections) by January 31st: Learn More
New Contributor II

## How to make a selective SUM for a chart

Hello everyone!

I´ll be probably making a very basic and silly question, but Im new

I have a table similar to this:

I want to make a pie chart to show how much dollars are per broker in a specific month.

In dimension I set the broker

In measure, if I use sum(value) it sums all the values, giving me always the following:

Broker A: 62

Broker B: 51

My expected result would be that if I create a chart for month 1 get the following values in the chart:

Broker A: 30

Broker B: 30

How do I make some kind of conditional SUM? (sum only when month equals 1) or there is another way?

THANK YOU SO MUCH IN ADVANCE!

PS: Im using qlik sense cloud

Tags (3)
1 Solution

Accepted Solutions
Honored Contributor III

## Re: How to make a selective SUM for a chart

Use set analysis to filter month specific records -

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

8 Replies
Honored Contributor III

## Re: How to make a selective SUM for a chart

Use set analysis to filter month specific records -

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

Valued Contributor

## Re: How to make a selective SUM for a chart

once you will  select Month pi will change to you are looking for

but if you want to have a static chart

for ever month

like Digvijay

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

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

New Contributor II

## Re: How to make a selective SUM for a chart

THANK you Jahanzeb & Digvijay very helpful!

New Contributor III

Contributor III

## Re: How to make a selective SUM for a chart

May be it will help ,try with this

Highlighted
Honored Contributor III

## Re: How to make a selective SUM for a chart

New Contributor II

## Re: How to make a selective SUM for a chart

Thank you everyone! I didn´t expectedsuch a fast reply and quality answers!

Three options worked in the very same way:

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

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

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

But I dont understand the differences among those three

Clarification would be very apprecitaed, thanks!

Valued Contributor

## Re: How to make a selective SUM for a chart

First and Last is same if there is no \$ qlik counts it \$ which tells that selection should be count in.

1 tels that selection should not be considered