Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
dustin_johan
Contributor II
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?

 

Thank you in advice...

1 Solution

Accepted Solutions
sunny_talwar

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

View solution in original post

2 Replies
sunny_talwar

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')
dustin_johan
Contributor II
Contributor II
Author

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

 

Thank you