Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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

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)

1 Reply
siddharth_s3
Contributor

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)

Community Browser