Bubble chart with Revenue on X axis and units on Y axis

[danialier]

Hello,

I'd like to build a Bubble chart in qlikview showing Revenues on X axis and Units on Y axis and then display the companies in bubbles in the graph.

I'm attaching the excel file, but I don;t know how to create this graph...

Can anyone help me on that ?

Thanks,

dani

[fvelascog72]

Hi,

I hope this helps you.

[MK_QSL]

Create a new Scatter Chart

Dimension

Customer

Expression

Tick Advanced Mode at the Bottom of Expression Tab

Use below expression

SUM(Revenue)

Sum ([Units sold])

[danialier]

Hello,

Federico, Manish, your answers were correct but I missed one point: I want the bubble size in the graph to be bigger in case there are two companies with the same number of revenue and units, so this is to have the bubble size in terms of number of companies in the same "point" in the chart.

I'm attaching an excel file where you'll see that D and H and companies B and I have the same number of revenues and units. How can I make the bubble bigger ?

Thanks,

dani

[MK_QSL · Accepted solution]

You can use third dimension which will be for Bubble Size

RANK(SUM(Revenue))

or

Rank(SUM([Units sold]))

or

RANK(SUM(Revenue)) + Rank(SUM([Units sold]))

[danialier]

Great Thanks Manish