topic Re: Scatter diagram in QlikView

Scatter diagram

Mon, 10 Jun 2013 06:53:55 GMT

Hi,

I'm trying to do a scatter diagram in QlikView and I'm not doing great so far.

What I'm trying to do is to create a QV from an existing excel document, and in this excel document there is a diagram like this:

The chart displays one dot per case. I have only managed to create charts with one dot per category (software, hardware etc) so far.

Each case has the following properties:

Response time
Category
Date

Any one who could help me?

Re: Scatter diagram

tresB — Mon, 10 Jun 2013 06:57:57 GMT

you might want to have a look here:

http://community.qlik.com/blogs/qlikviewdesignblog/2013/03/18/scatter-chart

Re: Scatter diagram

Mon, 10 Jun 2013 07:21:09 GMT

Hi,

I've seen this before, and it sure do help a bit. However, when I followed this guide the closest thing i could achieve was this:

I cannot make it anywhere close to the original:

For some reason the StartDate is suddenly all wrong. The startdate is formated as 'YYYY-MM-DD'
I can make a diagram for the category 'Annat', but not for all categories at once. When i do this, I get only one dot per category.

Re: Scatter diagram

hic — Mon, 10 Jun 2013 07:45:10 GMT

It looks as if the start date isn't interpreted correctly. But it is impossible to tell without looking at the data. Post some data, please.

HIC

Re: Scatter diagram

Mon, 10 Jun 2013 07:59:03 GMT

Hi,

I managed to correct the StartDate interpretation. It was automatically set to calculate the sum of the startdate, which naturally looked wiered for me.

I have now managed to create a scatterchart doing what i want, except that i cannot make it group by category type (hardware, software etc) like the picture in the first post.

The data is attached.

Re: Scatter diagram

hic — Mon, 10 Jun 2013 09:10:23 GMT

Make the following changes:

Set Dimension to "WorkFlowType"

Set Expression 1 to Avg(StartDate)

Set Expression 2 to Sum(ResponseTime)

HIC

Re: Scatter diagram

Mon, 10 Jun 2013 10:22:01 GMT

Thanks for your help. The problem is, when I do what you suggest I end up with only one dot per category. What i want is to make every WorkflowInstance to be displayed as a dot on the chart (with the dot color depending on what category the instance is associated with.

Re: Scatter diagram

hic — Mon, 10 Jun 2013 15:07:49 GMT

Then use "WorkflowInstance" as first dimension and "WorkFlowType" as second dimension.

If the following graph I have used "Country" as first dimension and "UN Region" as second. Note the colors.

HIC

Re: Scatter diagram

Tue, 11 Jun 2013 06:42:36 GMT

Thanks! This did the trick!

Richard