topic Finding cumulative value in a straight table in QlikView

Finding cumulative value in a straight table

Fri, 08 Jul 2016 17:38:47 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 levels.

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

Regards,

Pooja.

Re: Finding cumulative value in a straight table

trdandamudi — Fri, 08 Jul 2016 17:55:46 GMT

Give a try on the below expression for Cumulative:

RangeSum( Above(Sum(AMOUNT),0,RowNo()) )

Re: Finding cumulative value in a straight table

Mon, 11 Jul 2016 02:34:39 GMT

Hi Thiru,

Thanks for the response. For this example the given script is working fine but when i add the date column, it's not giving me the correct answer. PFA updated QVW file with the updated data.

Please help me if you can.

Thanks,

Pooja

Re: Finding cumulative value in a straight table

Anonymous — Mon, 11 Jul 2016 08:33:55 GMT

try to create a field like this

Autonumber(ID&'-'&DATE&'-'&NAME&'-'&AMOUNT,ID) as Key

then use this in your expression :

Rangesum(above(total sum(AMOUNT),0,Key))

Re: Finding cumulative value in a straight table

qliksus — Tue, 12 Jul 2016 08:59:00 GMT

I guess your question has been answered in the some other thread . You can use the below

RangeSum( Above(total Sum(AMOUNT),0,RowNo(total )) )