Aggr and ignoring selections

Anonymous — Fri, 29 Apr 2016 11:25:31 GMT

Hi,

I have a problem - the aggr function does not EVER take into account elements of the dimension excluded by some other selection.

I need to distribute the client count into ranges like '0%', '10%, '>10%'. These ranges represent the part of the selected Asset Class inside the client portfolio.

So, if I select Equity as the Asset Class, I want to see how many clients have 10% (or 0, or >10%) of their portfolio in Equity.

My chart contains a dimension - an aggr similar to this:

=Aggr(

    if( sum(CBV) / sum({$<Assets.Class=>} Total<ClientID> CBV) <=0,

          '0%',

    if( sum(CBV) / sum({$<Assets.Class=>} Total<ClientID> CBV) <=0.1,

          '10%',

          '>10%'

    )),

    ClientID

)

Then in the expression it simply does count(ClientID).

The total chart count of clients should be equal to the actual total of clients.

But it is not: when the Assets.Class gets selected, some (or sometimes many) clients get obviously excluded.

So, the chart total sometimes gives 1, sometimes 100, sometimes 45 out of 100 clients.

Can this be solved so that the missing clients would be treated as having 0% of the asset class?

The actual problem is: can the Aggr function do the calculation on ALL the values of the filtered dimension?

Re: Aggr and ignoring selections

Anonymous — Fri, 29 Apr 2016 11:28:10 GMT

Stupid me.

Count({$<Assets.Class=>} ClientID)

in the expressions solves the problem.

topic Re: Aggr and ignoring selections in QlikView

Aggr and ignoring selections

Re: Aggr and ignoring selections