topic Re: Cumulative value in QlikView

Cumulative value

Wed, 25 Nov 2020 16:16:04 GMT

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.

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

Regards,

Pooja

Anonymous — Mon, 11 Jul 2016 07:46:14 GMT

Hi try this ,

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

amit_saini — Mon, 11 Jul 2016 07:54:48 GMT

Like attached???

Thanks,

ecolomer — Mon, 11 Jul 2016 07:57:40 GMT

Try with for TOTAL

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

And by groups, see attached file

sushil353 — Mon, 11 Jul 2016 08:01:14 GMT

Please find attached.

HTH