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
alejnadro
New Contributor II

How to make a selective SUM (multiple columns) for a chart

Hello everyone!

I´m new at qlik so my questions may be very basic, but I guess we all started somehow similar   and iw worse not to ask.

I have a table similar to this:

Captura de pantalla 2018-03-16 a la(s) 11.54.35.png

If I want to sum the entire Value column I use:

Sum(Value)

(expected result: 254)


If I want to sum Value for the Month 1 I use:


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

(expected result: 102)

But, how do I sum Value for the Month 1 AND Broker BA ? 

(expected result: 62)


And how would it be to sum Value for month 1 AND Broker BA AND Stock A ?

(expected result: 10)


THANK YOU SO MUCH IN ADVANCE!

PS: Im using qlik sense cloud


1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Re: How to make a selective SUM (multiple columns) for a chart

Hey Alejandro,

This is what you need for your 1st and 2nd respectively:

Sum({<Month={1}, Broker={'BA'}>}Value)

Sum({<Month={1}, Broker={'BA'},Stock={'A'}>}Value)

View solution in original post

1 Reply
Highlighted
Partner
Partner

Re: How to make a selective SUM (multiple columns) for a chart

Hey Alejandro,

This is what you need for your 1st and 2nd respectively:

Sum({<Month={1}, Broker={'BA'}>}Value)

Sum({<Month={1}, Broker={'BA'},Stock={'A'}>}Value)

View solution in original post