topic Re: Cummulate in QlikView

Cummulate

Wed, 21 Aug 2013 12:40:07 GMT

Hello,

Every year, I keep the sales pro week in a table. Now i want to see the total sales counting also the sales in the weeks before.

I have following table

Year

2012 2011

Week nr

52 600 900

51 400 500

etc.

Now i want to have

Week 2012 2011

52 1000 1400

51 400 500

etc.

How do i do this?

Re: Cummulate

Wed, 21 Aug 2013 12:45:22 GMT

try this

RangeSum(Above(sum(fieldname),0, rowno()))

Re: Cummulate

Wed, 21 Aug 2013 12:51:38 GMT

Hi,

Why don't you just use a pivot table?

Dim1=Year

Dim2=Week

Expression=Sum (amount)

and then activate on presentation tab the "show partial sums" on Dim2.

Re: Cummulate

Wed, 21 Aug 2013 14:29:37 GMT

Hi,

How can i create a pivot table. I create a table but i don't succeed.

Re: Cummulate

Wed, 21 Aug 2013 14:33:55 GMT

here i become 0 as output

Re: Cummulate

Wed, 21 Aug 2013 15:43:22 GMT

???

right clik on the sheet, new sheet object, chart and then select the pivot table.

Re: Cummulate

Anonymous — Wed, 21 Aug 2013 16:27:15 GMT

try-

sum(aggr(rangesum(above(total sum({<Year=>}Amount),0,3)),Year)

Re: Cummulate

Thu, 22 Aug 2013 11:09:45 GMT

Thx! I succeeded. Problem was i had lowercase fieldname

Re: Cummulate

Thu, 22 Aug 2013 11:17:18 GMT

Hi VIshwarin,

now i have

52 200 200

51 400 600

but i want to have

52 200 600

51 400 400

how do i do that?