topic Re: 'Text' X- Axis for a Scatter Chart? in QlikView

'Text' X- Axis for a Scatter Chart?

mwallman — Wed, 18 Nov 2015 21:34:32 GMT

Hi all,

Is there a hack of some kind to create Text based X-Axis for a Scatter Chart?

I have tried numerous things like holding a text field as Dual and then using the field that way but it does not work.

If I put a 'ID' field for the Text values it works but I really want to show the actual names rather than an ID.

A workaround is using Line Graph with dots but then I cannot change the size of the bubbles like a scatter graph can with the third expression.

Does anyone know how to get a scatter chart to show text values in the X-Axis please?

Re: 'Text' X- Axis for a Scatter Chart?

swuehl — Wed, 18 Nov 2015 21:45:21 GMT

Have you looked into using a Grid Chart instead?

Re: 'Text' X- Axis for a Scatter Chart?

mwallman — Wed, 18 Nov 2015 21:51:26 GMT

I have tried that swuehl but it doesn't spread out the values proportionatly like a scatter graph does. It's very 'grid' based rather than free like a scatter graph.

Re: 'Text' X- Axis for a Scatter Chart?

MarcoWedel — Wed, 18 Nov 2015 23:50:48 GMT

Hi,

your x axis only having discrete values I guess you're talking about a continuous y axis.

What kind of data are you getting for this?

Can you post a sample?

Maybe you could precalculate equidistant values to get a nice scale there?

hope this helps

regards

Marco

Re: 'Text' X- Axis for a Scatter Chart?

mwallman — Thu, 19 Nov 2015 11:19:19 GMT

Hi Marco attached is an app with an example of what I am trying to achieve.

Re: 'Text' X- Axis for a Scatter Chart?

swuehl — Thu, 19 Nov 2015 12:55:45 GMT

It's strange that you can use CompanyName as X-axis expression here.

I believe both axis expressions need to return numeric values, that's the property of a scatter chart, as you said, showing two continuous numeric axis (in contrast to a grid chart).

If you remove the (optional) expression for z-value, your chart won't render, and you also see that the axis use the second and third expression, so I think what's happening is that QV skips CompanyName as x-axis expression and takes second and third as axis expressions.

I am not really sure what you are trying to achieve, since IMHO, text labels on x-axis won't make the chart really useable, given that the axis is numeric continuous, right?

Re: 'Text' X- Axis for a Scatter Chart?

MarcoWedel — Thu, 19 Nov 2015 20:55:02 GMT

Hi,

maybe you could use pop up texts an labels on datapoints instead of the company names on the x axis and sort by rank instead of a (quasi random) alphabetical order:

or simply use a bar chart?:

hope this helps

regards

Marco