New to Qlik Sense

[dustin_johan]

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...

[sunny_talwar · Accepted solution]

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]

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

Thank you