Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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