Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
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