topic Re: Need help to create a Bubble Chart with data labels in QlikView

Need help to create a Bubble Chart with data labels

Mon, 15 Dec 2014 11:36:48 GMT

Dear Friends,

I want to create a bubble chart. Please refer the sample attached.

I have a historical table which has last 10 years data. I would like to retrieve the top 10 performers (order by count) of each year with their contributions across the 12 months and show in a bubble chart (like the sample attached).

I have a year’s listbox on the top. So, if I choose ‘2011’ then the top performers of the year and their contributions for the 12 months should be displayed in a chart.

How can I do that? Please share your valuable suggestions.

Thanks,

Muru

Re: Need help to create a Bubble Chart with data labels

arulsettu — Mon, 15 Dec 2014 11:48:03 GMT

create a grid chart

Month as dimension

sum(performance) in expression

Re: Need help to create a Bubble Chart with data labels

francoiscave — Mon, 15 Dec 2014 11:48:29 GMT

HI Murugesh,

Can you post an application with some data to help us ?

Thanks,

François

Re: Need help to create a Bubble Chart with data labels

Mon, 15 Dec 2014 12:06:32 GMT

Hi Francois,

I am using Qlikview Personal Edition. We are testing the tool for our reporting requirement.

Is it possible to post application with this edition?

Re: Need help to create a Bubble Chart with data labels

francoiscave — Mon, 15 Dec 2014 13:05:27 GMT

Murugesh,

It will be possible to me to open it.

It's easier for us to help you.

François

Re: Need help to create a Bubble Chart with data labels

arulsettu — Mon, 15 Dec 2014 13:07:44 GMT

what is your dimensions and if possible post a screen shot

Re: Need help to create a Bubble Chart with data labels

Mon, 15 Dec 2014 13:43:10 GMT

Hi Arul and Francois,

I appreciate your time for writing back to the post. Since, I am working on a remote machine I cannot take a screenshot or share the application.

Anyway, now I've successfully created the chart. I was just switching the dimensions and expressions and I got 90% of the expected result. Now, I need a help to show the data labels on the bubbles.

So, kindly give me your valuable inputs on fixing the data labels on bubbles. My dimensions are Employee Name (X-axis), Publish date (Y-axis) and the expression is "Count of publish date". I would like to show Count of publish date (eg. 46) on the respective bubble.

Thanks again for your help.

Regards,

Muru

Re: Need help to create a Bubble Chart with data labels

arulsettu — Mon, 15 Dec 2014 13:54:58 GMT

in properties -> presentation -> enable labels on data points

Re: Need help to create a Bubble Chart with data labels

Tue, 16 Dec 2014 06:17:09 GMT

Arul,

But that option enables Y-axis value (Jan, Feb, Mar...) whereas I want to show the value of the expression (count of publish date). Please advice.

Re: Need help to create a Bubble Chart with data labels

arulsettu — Tue, 16 Dec 2014 07:00:19 GMT

why dont you try that with scatter chart

Re: Need help to create a Bubble Chart with data labels

Tue, 16 Dec 2014 14:04:01 GMT

I want to represent the count visually with the bubble sizes. That's the reason I've chosen bubble chart.