Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Markus_QV
Contributor III
Contributor III

RangeSum not working properly

Hi,

I have a problem with the Rangesum-Function in QV11 and hope someone can help me.

I want to accumulate a column(column(5)), but after some rows have accurately been added , QV is starting in the next row by 0 again (check date 20140606).

(Pls. also see the qvw and the xlsx-file)

Can someone explain to me why that happened?


Inv_Accum_Break_in_Couting.jpg

Best Regards

Markus

1 Solution

Accepted Solutions
jerem1234
Specialist II
Specialist II

Try:

rangesum(New#-Done#, below(New#-Done#, 1, NoOfRows()-RowNo()))

Hope this helps!

View solution in original post

8 Replies
anbu1984
Master III
Master III

Not able to open attached qvw

Markus_QV
Contributor III
Contributor III
Author

Pls. try the new version...

antoniotiman
Master III
Master III

Hi Markus,

try

RangeSum(Top(New#-Done#,1,RowNo()))

Regards,

Antonio

anbu1984
Master III
Master III

Try this

Rangesum(New#-Done#,Above([Accumulated]))

jerem1234
Specialist II
Specialist II

Try:

rangesum(New#-Done#, below(New#-Done#, 1, NoOfRows()-RowNo()))

Hope this helps!

Markus_QV
Contributor III
Contributor III
Author

It's working, but not in the way we need...

we need to start with the accumulation from the oldest date to the youngest....

ScreenShot677.jpg

Markus_QV
Contributor III
Contributor III
Author

Perfect! That's working...

Thank you very much.....

anbu1984
Master III
Master III

Check this