topic Running sum maximal agg value in QlikView

Running sum maximal agg value

Tue, 08 Dec 2009 22:00:05 GMT

Hi all,

which is the easiest way to get max value of running sum by year, quarter, month and day?

Thanks 🙂

Oleg_Troyansky — Tue, 08 Dec 2009 23:38:02 GMT

I'm not sure exactly what you are trying to do, but it looks like you need Advanced Aggregation:

max( aggr( sum(Sales), Year, Quarter,...))

cheers,

Wed, 09 Dec 2009 14:52:47 GMT

Hi Oleg,

I need max but looking at cumulative sum on yearly, quarterly, monthly and daily levels.

For ex.

Posting date Quantity

1.1.2010. 5

2.1.2010. -4

1.2.2010 1

1.4.2010. 9

1.6.2010. -3

When looking at the year, max cumulative value is 11 (5-4+1+9).

When looking at monthly granualtion, max values are jan:5, feb: 5-4+1 = 2, march: 3, apr: 9+3=12

I know I can't have march unless I create a calendar, but how would i get max cumulative values for the periods in which I do have something posted?

Thnx.