topic Help with Bubble Chart in QlikView

Help with Bubble Chart

ulyxess1983 — Thu, 15 Dec 2011 16:25:23 GMT

Hi folks,

Need some advice.

I want to get a bubble chart with:

X-axis - Customer Group

Y-axis - average profitabilty of Customer Group (i.e. 0.14)

Bubble - Sum of gross sales

I set my dimensions as Customer Group and Avg(Gross) and expressions as Sum(Gross), but I have an error message for my calculated dimension (avg(gross)). any ideas ?

Thanks,

Mikhail

Help with Bubble Chart

brenner_martina — Thu, 15 Dec 2011 16:33:25 GMT

Hi, Mikhail,

please, what does the error message say?

Greetings from Munich

Martina

EVACO GmbH

Help with Bubble Chart

matt_crowther — Thu, 15 Dec 2011 16:40:43 GMT

Mikhail,

I'd suggest that type of chart isn't best suited to a Bubble / Scatter Chart (at least as you describe) as you have a non-continuous dimension (Customer Group).

Personally I'd use a combo chart with X as Customer Group and both Avg Profitability and Sales as the Y values, I'd use a bar to display the Sales (as your X dimension is non-contiguous and therfore each value bears no relation to the next so they shouldn't beconnected by a line chart) and Symbols to display tghe Avg Profitability, you'll need to split the Axis in 2; Sales on the left, Profitability on the right.

I use Scatter and Bubble charts where I have one dimension (Customer Group) and 2 axis expressions (sum of Sales and Count of Volume - your example has 1 dimension, 1 axis expression and 1 size expression) as in the example below:

We have 'Quotes' across the X-Axis and 'Premium' across the Y-Axis, the bubbles are split by 'Product Type' (there is no size expression as it's not needed).

As a rule; the X and Y axis of a scatter chart should always be continuous.

Hope that helps,

Matt - Visual Analytics Ltd

Re: Help with Bubble Chart

ulyxess1983 — Mon, 19 Dec 2011 10:22:20 GMT

Hi Matt,

I need such a type of graph:

I attach data.

I just don't get how to make such a graph.

Help with Bubble Chart

vijay_iitkgp — Mon, 19 Dec 2011 10:41:20 GMT

Hi,

You can use Grid Chart instead of Scatter chart.

Help with Bubble Chart

ulyxess1983 — Mon, 19 Dec 2011 10:46:06 GMT

Hi Vijay,

Can you say what did you use as dimensions and what as expressions?

Also - I have data that relates to current client, not group, like this:

measure, customer, product

and i need to make a chart using groups of clients and groups of products.

will this chart work?

Help with Bubble Chart

ulyxess1983 — Wed, 21 Dec 2011 09:57:59 GMT

Guys,

I've made this chart with calculated dimension like Aggr(Avg(Measure, Step), Level1), but I need to make a universal chart with drill down option from Level1 to Level3 or even to Product Groups.

Any ideas?