Qlik Community

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
alejnadro
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:

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
Highlighted
Digvijay_Singh
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)

View solution in original post

8 Replies
Highlighted
Digvijay_Singh
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)

View solution in original post

Highlighted
zebhashmi
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)

Highlighted
alejnadro
New Contributor II

Re: How to make a selective SUM for a chart

THANK you Jahanzeb & Digvijay very helpful!

Highlighted
hdbucher
New Contributor III

Re: How to make a selective SUM for a chart

image.png

Highlighted
chinnuchinni
Contributor III

Re: How to make a selective SUM for a chart

294956.PNG

May be it will help ,try with this

Digvijay_Singh
Honored Contributor III

Re: How to make a selective SUM for a chart

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

Highlighted
alejnadro
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!

Highlighted
zebhashmi
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