topic Re: How to Manually Accumulate a column ? in QlikView

How to Manually Accumulate a column ?

Wed, 04 Jul 2012 15:06:36 GMT

Dear All

In straight table it has a function full acumlation, which accumulated value not able to divide by another column because it takes the actual value of that accumulated field so i want to accumulate the field manually any one can help me ?

Re: How to Manually Accumulate a column ?

swuehl — Wed, 04 Jul 2012 15:47:06 GMT

Try using

=rangesum( Above( YOUREXPRESSION, 0, rowno() ))

Re: How to Manually Accumulate a column ?

Thu, 05 Jul 2012 05:54:31 GMT

Hi Vignesh,

Try this in the script->

numsum(count,peek('sum_count')) AS sum_count

Regards

Apurva