topic Re: Accumulation in Qlik Sense in App Development

Accumulation in Qlik Sense

Tue, 23 Sep 2014 10:15:49 GMT

Hi,

Anyone out there who knows how to accumulate a measure in a chart object in Qlik Sense. In QlikView I used to choose "Full accumulation" on the expressions tab, but there's no such feature in Qlik Sense, from what I can see...

Thanks

Pedro

Re: Accumulation in Qlik Sense

Giuseppe_Novello — Tue, 23 Sep 2014 13:12:35 GMT

Pedro,

It seems that "Full accumulation" is not yet implemented in Sense ( looking at the help area), however, I would guess there would be a a way by doing set analysis, hopefully someone can provide such workaround. ( sorry I am not a developer guru =( )

Gio

Re: Accumulation in Qlik Sense

Tue, 23 Sep 2014 13:39:06 GMT

Hi Pedro,

In Sense (as in QlikView), you can use the RANGESUM function in combination with the ABOVE function to accumulate the values you need.

In this case, you could use an expression like this:

rangesum( above( sum([Expression1]),0,rowno()))

To get this result (left: original graph; right: accumulation with RANGESUM):

Re: Accumulation in Qlik Sense

Anonymous — Tue, 23 Sep 2014 13:46:26 GMT

Hi Pedro,

Here is a work-around that you can use for the Sense UI measures. Try using the RangeSum and Above/Below commands.

Example:

RangeSum(Above(Sum(FieldName),0,rowno()))

Cheers,

Sean

Re: Accumulation in Qlik Sense

Anonymous — Tue, 23 Sep 2014 13:50:11 GMT

Thanks Borja. You beat me to it!

Re: Accumulation in Qlik Sense

Tue, 23 Sep 2014 19:53:04 GMT

The RangeSum function did the trick.Thank you both ever so much for the help!

Re: Accumulation in Qlik Sense

Tue, 16 Dec 2014 02:25:55 GMT

Hey Borja,

Do you know how I can get this to work with Multiple Dimensions?

For example I have a stacked bar chart with 2 dimensions and 1 expressions, but this expression is not accumulating in QlikView Sense " rangesum( above( sum([Expression1]),0,rowno())) "

Thank you!

Ben

Re: Accumulation in Qlik Sense

Tue, 11 Aug 2015 14:45:03 GMT

Hi,

Does anyone how the expression would be if it was a line chart rather than a bar chart??

I tried applying the expression above and it didn't work.

Many thanks in advance.

Azeem

Re: Accumulation in Qlik Sense

nico_ilog — Mon, 30 Nov 2015 08:20:27 GMT

Found this awesome video that explains it perfectly.

https://www.youtube.com/watch?v=AlT_jAMsiGU

Credit to: Christof Schwarz

The basic idea is this:

1. Create 2 variables in Qlik Sense. I just used the editors variable creation window.

Variable 1:

Name:accum

Value:='RangeSum(Above('

Variable 2:

Name:/accum

Value:=',0,RowNo(TOTAL)))'

Usage:

$(accum)(Your Measure)$(/accum)

NOTE:

If you are going to create the variable using the SET function, in the script. Then you need to change these (' ') to these (" ").

Let me know if it helped.

Nico

Re: Accumulation in Qlik Sense

Thu, 03 Dec 2015 15:46:57 GMT

Borja,

What does the 0 mean in that equation?

rangesum( above( sum([Expression1]),0,rowno()))

Re: Accumulation in Qlik Sense

nico_ilog — Thu, 03 Dec 2015 20:21:32 GMT

Hi Channing Dionisopoulos,

This video explains it.

How to produce a cumulating bar chart/line chart in Qlik Sense - YouTube

Regards,

Nico

Re: Accumulation in Qlik Sense

Mon, 18 Apr 2016 20:30:43 GMT

Thanks you! It's works.

Re: Accumulation in Qlik Sense

munna1317 — Wed, 07 Dec 2016 12:35:00 GMT

Great Work ,

Small Question on Extension to this Question ,

What if we have 2 Expression and 2 Dimension vas well, i am trying using aggr funtion in Qlik Sense it is Not working .

Can you please help me out of this .

I am Trying like this but not working

=Max( Aggr( rangesum( above( Sum(Aggr(sum({<No = {10}>} Expression),Filed-1,Field-2)),0,RowNo())),

Filed-1,Field-2))

Thanks in advance ,

Harish

Re: Accumulation in Qlik Sense

Fri, 09 Dec 2016 21:58:09 GMT

Hi,

What if we want to have all line on the same chart?

Two dimension:

1) Year

2) Fieldname

Two mesures:

--> Sum per fieldname over the year -> Sum(FieldName)

--> Total sales over the year. --> RangeSum(Above(Sum(FieldName),0,rowno()))

But standard line chart only accept one mesure. How can I solve this?

Re: Accumulation in Qlik Sense

saniyask — Thu, 16 Nov 2017 11:46:43 GMT

Hi,

This is working fine.. but what If I am restricting my dimension to say top 5. in this scenario its not giving proper numbers.

Saniya.