Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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

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)

alejnadro
New Contributor II

Re: How to make a selective SUM for a chart

THANK you Jahanzeb & Digvijay very helpful!

hdbucher
New Contributor III

Re: How to make a selective SUM for a chart

image.png

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.

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!

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