Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Cumulative value

Dear Friends,

I need a help in finding cumulative value in a straight table for the attached QVW file.

I wanted to find the cumulative values based on ID.

Cum.jpg

Result should be like the below:  (Based on the ID the cumulative values will be)(this sample is from Excel)



Cum_Answ.jpg


Regards,


Pooja

4 Replies
Anonymous
Not applicable
Author

Hi try this ,

---- RangeSum(Above(Sum(your value),0,RowNo()))

amit_saini
Master III
Master III

Like attached???

Thanks,

AS

ecolomer
Master II
Master II

Try with for TOTAL

=RangeSum(above(total Sum(AMOUNT),0,RowNo(Total)))

P_224445.png

And by groups, see attached file

sushil353
Master II
Master II

hi

Please find attached.

HTH