topic Re: Creating a scatter chart - providing the right data. in QlikView

Creating a scatter chart - providing the right data.

Wed, 27 Jun 2012 00:10:24 GMT

I am trying to create a scatter chart with data coming from a single table. I want to see a scatter (X,Y) relationship between the price of a unit and the number of units sold. What do I do to provide the data to through the create chart wizard to make the scatter plot draw correctly? In other words, when I specify the dimensions, X should be price per unit, and Y should be number of units sold.

So far, I am not providing data to Qlikview in the manner it wants to render such a graph. I am a long time Excel user, but trying my best to use a tool such as Qlikview.

I have searched several places trying to find an example of a scatter plot.

Any help is greatly appreciated.

Thanks,

Ben

Re: Creating a scatter chart - providing the right data.

kevinpintokpa — Thu, 18 Oct 2012 21:44:38 GMT

Ben, did you ever receive a response to your question or figure out the answer?

You might need to consider whether a grid chart would fit your needs.

I've attached a very simple .qvw file which has the most basic data set:

LOAD * INLINE [
    X, Y
    1, 10
    2, 20
    3, 30
    4, 40
    5, 50
    6, 40
    7, 30
    8, 20
    9, 10
    10, 0
    1, 5
];          // Note the repeated X value of 1

You can see how the grid chart shows each data value separately and the scatter chart sums up the Y field.

Re: Creating a scatter chart - providing the right data.

Sat, 20 Oct 2012 02:15:04 GMT

I did get this resolved. Easier than I thought. Create a scatter chart (first picture, lower left icon), and then choose the X,Y properties on the expressions tab.

Thanks,

Ben