topic Re: Total Mode in QlikView

Total Mode

Anonymous — Fri, 31 Aug 2012 13:09:39 GMT

I have managed to get the the answer that I want by using the F(x)=min in the Total Mode section of the expressions tab for graphs. I now only want to display this value for each of the portfolios in my first dimension. My first dimension is portfolio name, my second dimension is FromDate, and my thrid dimension is AsOfDate. This allows me to calculate cumulatives returns for each portfolios by doing this for every date combination. I then just look for the minimum value as my maximum drawdown.

Is there anyway to suppress anything except that value, or an alternative way of getting to the same answer?

Any help would be appreciated.

Thanks.

Joao.

Re: Total Mode

whiteline — Fri, 31 Aug 2012 16:02:12 GMT

Maybe,

=min(aggr(Sum(x), portfolio, FromDate, AsOfDate))

Of course, you should use it with one dimension portfolio.

I also assumed that you've calculated your value for each portfolio, FromDate and AsOfDate with simple Sum(x).

Replace it with your ecpression.

Re: Total Mode

Anonymous — Sat, 01 Sep 2012 08:33:57 GMT

Works brilliantly. Thank you so much.

Sent from my iPad