Announcements
The way to achieve your own success is the willingness to help somebody else. Go for it!
cancel
Showing results for
Did you mean:  Contributor II

## Full Accumulation Qlik Sense

Hi everyone, I'm trying to use the full cumulative sum in Qlik Sense, which is possible to use this function through the construct Rangesum(Above/Below(  .

I achieved the right result in a pivot table, but when I try to use it in a barchart, in order to display the cumulative sum by bars, the output is "the selections generated no data for this chart".

The function which works in the table but not in the barchart is the following:

`num(rangesum(before(\$(=only({\$<FOB={'v_VAl_KCS'},DESC={'\$(v_BIGNL)'}>}TAB)),0,ColumnNo()))/100, '#.##0,0')`

Can you help me guys?

1 Solution

Accepted Solutions  MVP

Change Before() to Above() and ColumnNo() to RowNo()

`Num(RangeSum(Above(\$(=only({\$<FOB = {'v_VAl_KCS'}, DESC = {'\$(v_BIGNL)'}>} TAB)), 0, RowNo()))/100, '#.##0,0')`
2 Replies  MVP

Change Before() to Above() and ColumnNo() to RowNo()

`Num(RangeSum(Above(\$(=only({\$<FOB = {'v_VAl_KCS'}, DESC = {'\$(v_BIGNL)'}>} TAB)), 0, RowNo()))/100, '#.##0,0')`  Contributor II
Author

I solved with your suggestion plus an aggregation of all the considered dimension.

Thank you Tags
Community Browser