topic Max value of Aggregation in QlikView

Max value of Aggregation

Tue, 25 Jun 2013 14:44:14 GMT

Hi,

I have a chart containing cumulated data using this expression:

=RANGESUM(

ABOVE(

SUM({<

[Measures (Key)]={'Operating Profit (EBIT)'},

[Version single (Key)]={'Actual'},

Period,

[Year period 1]={$(vTwelveMonthRolling_All)}

>}Values)/1000000

,

0

,

RowNo()

)

)

With this dimension: [Year period 1].

My question is, how to calculate the highest and the lowest value from this chart expression within a simple text-object.

This means if my data looks like this:

Year period 1	Single values	Cumulated values
Jan 13	36,1	36,1
Feb 13	4,2	40,3
Mar 13	80,1	120,4
Apr 13	-68,8	51,6
May 13	62,1	113,7
Jun 13	67,3	181
Jul 13	-63,4	117,6
Aug 13	88,1	205,7
Sep 13	-14,7	191
Oct 13	97,7	288,7
Nov 13	-90,9	197,8
Dec 13	33,1	230,9

And I would like to receive the highest value from the cumulated column (col 3): 288.7 Oct 13

Any suggestions?

Re: Max value of Aggregation

Gysbert_Wassenaar — Tue, 25 Jun 2013 17:07:35 GMT

Something like this:

max(aggr(RANGESUM(

ABOVE(

SUM({<

[Measures (Key)]={'Operating Profit (EBIT)'},

[Version single (Key)]={'Actual'},

Period,

[Year period 1]={$(vTwelveMonthRolling_All)}

>}Values)/1000000

,

0

,

RowNo()

)

)

,[Year period 1]))

See attached example.