topic Re: How to sum across rows in a pivot table (running total) in QlikView

How to sum across rows in a pivot table (running total)

Tue, 03 Dec 2013 06:23:32 GMT

Hi All

I have a pivot table with monthly total across 12 months in a pivot table

I have tried using the function RangeSum(sum(total), before(sum(total))) to create a running total YTD total but it is not consistent

Is there another function that will allow me to create a running total

e.g

Jan feb Mar Apr

AP 10 20 30 40

AP YTD 10 30 60 100

Cheers

Brett

Re: How to sum across rows in a pivot table (running total)

MayilVahanan — Tue, 03 Dec 2013 06:33:29 GMT

Try like this

Calculating rolling n-period totals, averages or other aggregations

Re: How to sum across rows in a pivot table (running total)

jagan — Tue, 03 Dec 2013 06:45:12 GMT

Hi,

Try this expression and please find attached file for solution.

=RangeSum(Alt(Before([AP YTD]), 0), Sum(AP))

Regards,

Jagan.

Re: How to sum across rows in a pivot table (running total)

Tue, 03 Dec 2013 21:46:07 GMT

Thanks Jagan

I am finally understanding how Pivot tables work , Cheers Brett

Re: How to sum across rows in a pivot table (running total)

Wed, 04 Dec 2013 03:22:10 GMT

Thanks Jagan

I am finally understanding how Pivot tables work , Cheers Brett

Re: How to sum across rows in a pivot table (running total)

Wed, 04 Dec 2013 03:33:46 GMT

Is it also possible to perform a %YTD calculation in a line chart given the same scenario. I have tried using accumulation using sum(AP)/sum(TP) but do not get the correct result

e.g

Jan feb Mar Apr

AP 10 20 30 40

AP YTD 10 30 60 100

TP YTD 15 35 65 110

Re: How to sum across rows in a pivot table (running total)

Wed, 26 Nov 2014 11:21:02 GMT

Hi Jagan,

Thanks a lot lot lot..............

Regards,

Sagar Gupta