3 Replies Latest reply: Nov 29, 2012 1:57 PM by whiteline _ RSS

    "Layered" bubble chart - how?

      Hi all,

       

      I’m trying to construct a “layered” bubble chart – meaning that I first want the aggregated bubbles to be showed, but if you click one of them, I want to see the underlying bubbles individually. Properly a bit confusing – allow me to elaborate:

       

      Consider a car dealer with two branches and the following data:

       

      Date

      Branch

      Brand

      SalesPerson

      Price

      Profit

      2012-10-01

      1

      Ford

      John

      15,000

      1,000

      2012-11-01

      1

      Aston Martin

      Robert

      25,000

      3,500

      2012-11-27

      1

      Aston Martin

      John

      30,000

      4,000

      2012-10-10

      1

      Ford

      Jeff

      12,000

      1,200

      2012-11-15

      2

      Aston Martin

      Jeff

      25,000

      2,000

      2012-11-20

      2

      Ford

      Jeff

      18,000

      1,800

      2012-10-05

      2

      Ford

      Brian

      20,000

      6,000

      2012-10-28

      2

      Ford

      Brian

      17,000

      8,000

       

      X-Axis: Average Price

      Y-Axis: Average Profit

      Bubble size: Number of salespersons


      Bubbles: Branches (one for each)

       

      Like this: 

       

      Bubble 1.JPG

       

      So far so good – this I can construct simply using a scatter chart in QlikView. However, I would like to be able to click Branch 1 and the chart should change to show bubbles averaged over brands for branch 1 – i.e. average price and profit for Ford and Aston Martin sold at Branch 1. The bubble size is still to count the number of sales person selling the particular brand. Clicking on Branch 1 should yield the following result in the chart: 

       

      Bubble 2.JPG

       

      Any suggestions on how to do so? Without having to create a separate chart.