aggr with set analysis

Anonymous — Mon, 17 Sep 2012 10:57:55 GMT

I am trying to do the following without much success.

I want to create a line chart with a trellis for the first dimension (PortfolioName). The second dimension is AsOfDate. I want the following expressions: First, I want 12 month rolling returns for the portfolio (easy). Second, I want the max and min (actually various fractiles) for all the portfolios. I therefore want to by pass the single portfolio selection caused by the trellis iterating through each of my portfolios (first dimension).

Unfortunately, the Qlikview help file and pop-up for the aggr function seem to differ when it comes to where the set analysis happens (the first says it is before the expr, while the second says it is after dim as such:

aggr ([ distinct | nodistinct ] [{set_expression}]expression {, dimension})

dual Aggr ({[DISTINCT][NODISTINCT]}expr, dim{, Expression})

Please can someone help me figure out which one to use, and how to achieve the above?

Any help would be greatly appreciated.

Thanks.

Joao

PS: If I ignore the trellis part of the exercise above, I can get the correct values for the min and max.

Re: aggr with set analysis

chematos — Mon, 17 Sep 2012 13:37:41 GMT

Think aggr() as a group by:

aggr( your expression, Dimension1, Dimension2, ..., DimensionN)

so the Dimensions are the field of the grouping, do you understand?

topic aggr with set analysis in QlikView

aggr with set analysis

Re: aggr with set analysis