Aggregation and Alternate States

nicogene — Tue, 17 Feb 2015 11:35:21 GMT

Dear all,

In the exemple in attachment, I would like to aggregate value in one bubble for the listbox named 'MyBrand'.

I have used 2 states in one expression.

For example, if I select two brand in the listbox named 'My brand', I would like to have one bubble with the aggregation of AuM and net flows.

For the listbox named 'Competitors', if I select one or more values, I would like to have one bubble per company.

Many thanks in advance for your help.

Kindest regards,

Nicolas.

Re: Aggregation and Alternate States

Joseph_Musekura — Thu, 19 Feb 2015 10:10:19 GMT

Dear Sir,

For this case “For example, if I select two brand in the listbox named 'My brand', I would like to have one bubble with the aggregation of AuM and net flows”, below are my observations:

For a "scatter chart ", a bubble is related to a dimension's value (where expressions are represented by X and Y-coordinate). Thus it is, I suppose, not possible to aggregation of AuM and net flows in ONE bubble.

But if you remove this dimension “ManCo” and add a calculated dimension (=1), then you have ONE bubble with AuM and net flows (see attached *.qvw sample). This is not what you want to do.

I changed your expression as well to:

=if( GetSelectedCount(ManCo , ';', 'Peer1') >=1 ,
   if( GetSelectedCount(ManCo , ';', 'Peer2') >=1, sum({<ManCo= [Peer1]::ManCo+[Peer2]::ManCo >}AuM), sum({[Peer1]}AuM)
     )
   )

Note: This is not the case in Straight table for example. Also a text object will aggregate the two states == > you should use 2 charts for a better comparison of the 2 states.

/joseph

topic Re: Aggregation and Alternate States in QlikView

Aggregation and Alternate States

Re: Aggregation and Alternate States