topic Re: Cumulative Sum in QlikView

Cumulative Sum

sadiaasghar — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Cumulative Sum

alex00321 — Thu, 27 Aug 2020 06:57:36 GMT

Hi,

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

Re: Cumulative Sum

sadiaasghar — Thu, 27 Aug 2020 08:11:13 GMT

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.

Re: Cumulative Sum

alex00321 — Wed, 09 Sep 2020 02:39:48 GMT

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