How to make a selective SUM for a chart

[alejnadro]

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

[Digvijay_Singh · Accepted solution]

Use set analysis to filter month specific records -

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

[zebhashmi]

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)

[alejnadro]

THANK you Jahanzeb & Digvijay very helpful!

[Anonymous]

[chinnuchinni]

May be it will help ,try with this

[Digvijay_Singh]

Great! Please close the thread by marking correct and helpful answers.

[alejnadro]

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!

[zebhashmi]

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