Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
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.
Think aggr() as a group by:
aggr( your expression, Dimension1, Dimension2, ..., DimensionN)
so the Dimensions are the field of the grouping, do you understand?