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: 
sadiaasghar
Contributor
Contributor

Cumulative Sum

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

I wanted to find the cumulative values based on project levels.

RangeSum( Above(total Sum([Progress Description]),0,RowNo(total )) )

It's working fine for me. But it's treating all the projects as same. I am attaching qvw file for reference.

 

3 Replies
alex00321
Creator II
Creator II

Hi,

Could you check if attached file meets your requirement? Thanks!

sadiaasghar
Contributor
Contributor
Author

Thanks Alex. It serves the purpose.

I have tons of different formulas for two fields Monthly Step Weight-age and Overall Weight-age for every record based on the project. And i have to calculate multiple Cumulative for the formulas. So should i evaluate them in load script or in expression. I am attaching Excel Sheet for reference and can you please look into my formulas too. 

alex00321
Creator II
Creator II

I would suggest you put the calculation in the back end. So it will reduce the potential performance issue in the front. Thanks!