# New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Qlik Cloud Maintenance is scheduled between March 27-30. Visit Qlik Cloud Status page for more details.
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