Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
alejnadro
Contributor II
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:

Captura de pantalla 2018-03-15 a la(s) 14.24.43.png

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

1 Solution

Accepted Solutions
Digvijay_Singh

Use set analysis to filter month specific records -

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

View solution in original post

8 Replies
Digvijay_Singh

Use set analysis to filter month specific records -

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

zebhashmi
Specialist
Specialist

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
Contributor II
Contributor II
Author

THANK you Jahanzeb & Digvijay very helpful!

Anonymous
Not applicable

image.png

chinnuchinni
Creator III
Creator III

294956.PNG

May be it will help ,try with this

Digvijay_Singh

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

alejnadro
Contributor II
Contributor II
Author

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
Specialist
Specialist

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