Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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!