Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Not applicable

Accumulation in Qlik Sense

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

1 Solution

Accepted Solutions
Not applicable

Re: Accumulation in Qlik Sense

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

rangesum.png

View solution in original post

14 Replies

Re: Accumulation in Qlik Sense

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

Giuseppe Novello
Principal Technical Support Engineer @ Qlik
Not applicable

Re: Accumulation in Qlik Sense

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

rangesum.png

View solution in original post

sod
Contributor

Re: Accumulation in Qlik Sense

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

sod
Contributor

Re: Accumulation in Qlik Sense

Thanks Borja.  You beat me to it! 

Not applicable

Re: Accumulation in Qlik Sense

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

Not applicable

Re: Accumulation in Qlik Sense

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

Not applicable

Re: Accumulation in Qlik Sense

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

nico_ilog
Contributor II

Re: Accumulation in Qlik Sense

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

Not applicable

Re: Accumulation in Qlik Sense

Borja,

What does the 0 mean in that equation?


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