Aggr and Set Expression

Thu, 06 Sep 2012 06:34:46 GMT

I am stuck with the Aggr function which tends to return nothing instead of my requested value.

I am also a bit confused as of where to place the set expression and whether to use max or rangemax:

1) =max ( Aggr( sum( { [S1] <AccountID={1200} >} Value), Year) )

2) =rangemax ( Aggr ( sum( { [S1] <AccountID={1200} >} Value), Year) )

placing the set after Aggr shows me the red underline on the first "{" so I assume the documentation is incorrect which states that I can use a set expression after Aggr?

3) =max ( Aggr( {[S1] <AccountID={1200} >} sum(Value), Year) )

4) =rangemax( Aggr( {[S1] <AccountID={1200} >} sum(Value), Year )

I also tried

5) =max({[S1] <AccountID={1200} >} Aggr(sum(Value), Year))

I tried it also with using other dimensions than Year and some of them returned results but I can't figure out where I am going wrong.

Juerg

Re: Aggr and Set Expression

Jason_Michaelides — Thu, 06 Sep 2012 06:40:40 GMT

What is [S1]?

Re: Aggr and Set Expression

Thu, 06 Sep 2012 06:51:22 GMT

I need to sync the scaling in different graphs which reside in different Alternate Selection Sets. These are named S1, S2 etc. So instead of using $ I need to use [Alternate Set Name].

topic Re: Aggr and Set Expression in QlikView

Aggr and Set Expression

Re: Aggr and Set Expression

Re: Aggr and Set Expression