topic Very basic Scatter chart in Qlikview in Water Cooler

Very basic Scatter chart in Qlikview

Fri, 03 Feb 2012 17:17:36 GMT

I am trying a do a very basic scatter chart in Qlikview, I don't need any calcuated fields I just need to present two fields as a scatter chart, as you would in Excel and am having problems.

How do you create a chart without using an expression, just taking two set of data as it is?
One of my axis is showing correctly (Year), however the other (Cost) is trying to show all values rather than just the sensible ones that should be on the axis. This has meant that the labels aren't going along the bottom/horizontal axis correctly, they are all bunched up.

Thank you, we are really stuck!!!

Very basic Scatter chart in Qlikview

hic — Fri, 03 Feb 2012 17:30:04 GMT

Since both axes are numeric, you need expressions to define them. If you do not use expressions, QlikView will assume the Only-function.

I suspect you should use the following two expressions:

* Only(Year) - or Min(Year); Max(Year), ...

* Sum(Cost)

And then you need a field as dimension - this is the field thet defines how many dots/bubbles you will get. If you want one dot/bubble per Product, then Product should be your dimension.

Do you have an example to post?

Very basic Scatter chart in Qlikview

Mon, 06 Feb 2012 09:41:21 GMT

Thanks Henric, I have had a go but still cannot get it to work, (I am a very new user!)

Would it be possible for me to upload an Excel file with some dummy data so you see what I mean?

Very basic Scatter chart in Qlikview

Mon, 06 Feb 2012 09:47:26 GMT

Year	Cost
2002	5000
2002	2000
2003	2500
2004	6000
2005	3050
2006	1000
2006	50
2006	2500
2006	3000
2007	35600

I have put some sample data in above. I need to show a bubble for each cost, not multipled together for the year but each separate cost showing as a separate entry at the appropiate size for the year. Is this possible?

Thanks for your help.

Very basic Scatter chart in Qlikview

CELAMBARASAN — Mon, 06 Feb 2012 10:06:14 GMT

Hi,

It is possible if you use cost as dimension.

Celambarasan

Very basic Scatter chart in Qlikview

Mon, 06 Feb 2012 13:42:58 GMT

Thanks everyone for your answers. We have finally done it!

Re: Very basic Scatter chart in Qlikview

hic — Mon, 06 Feb 2012 13:44:16 GMT

For a scatter chart you need one dimension (discrete values) and two measures (numbers; continuous values).

For a grid chart you need two dimensions and one measure. So my first question is - which of the two do you want? (See attachement with your sample data.)

The second question is: Do you have an additional field that you can use in the chart? I added a mock-up "Product" and a mock-up "Profit" to your data. Su my grid chart has Year and Product as dimensions, and my scatter chart has Cost and Profit as measures.