topic Re: How to make a scatter chart with x with discrete values ? in QlikView

How to make a scatter chart with x with discrete values ?

fredericvillemi — Mon, 24 Oct 2016 13:46:01 GMT

Hello,

I'm looking for a way to make a mix between Scatter Chart and Grid Chart.

I would like to make a Scatter chart but the x dimension is a value that has two different companies values

It means I want the y to be continuous and the x to be discrete values.

Is there a trick to do that ? and do you know an extension that could do that ?

Thanks

Re: How to make a scatter chart with x with discrete values ?

MarcoWedel — Mon, 24 Oct 2016 21:01:41 GMT

please post some sample data and your expected result.

thanks

regards

Marco

Re: How to make a scatter chart with x with discrete values ?

johnw — Mon, 24 Oct 2016 21:22:25 GMT

X can certainly just have two discrete values. Make a scatter chart and go.

But if you have a lot of data, you'll just see two lines on your screen, which isn't much use. So I'll give you a couple tricks I use. First, I make the color of the points fairly transparent. For instance, argb(50,100,100,200). I have no idea if that's a decent color, but the idea is that it takes multiple points in close proximity to build up color, so you can get a better idea what's going on with your Y dimension. The other thing I do is randomly offset the X value. So if I have X values 10 and 20, I might use x-4.5+rand()*9, say. I'll then get something more like bars instead of lines. This combines well with the semi-transparent colors if you still have so much data that you're getting fairly dark bars. I've even used a variable and slider for the transparency, because user selections can have a big impact on how much data there is, and if there's a lot, different levels of transparency can highlight different patterns in the data.

Re: How to make a scatter chart with x with discrete values ?

fredericvillemi — Wed, 26 Oct 2016 14:33:15 GMT

For example, I want to compare two shops

Shop1 and Shop2 would be on x axis.

On y, i would love to have prices

on size of bubbles, i would have the number of items sold for each price as the size of the bubble

The problem is if i use Scatter Chart I can't have a shop name on X

And if I use Grid Chart, i don't have continuous x for prices ..

Re: How to make a scatter chart with x with discrete values ?

fredericvillemi — Wed, 26 Oct 2016 14:34:54 GMT

Thanks John for you very interesting method with random x and alpha colors.

For the discrete values, I can convert my string values to numbers but I would have loved to be able to use names on x and continuous y .. I think it's not possible.

Thanks

Re: How to make a scatter chart with x with discrete values ?

johnw — Wed, 26 Oct 2016 17:12:01 GMT

It's possible if you cheat a little by using a text object for the names, and dual() when defining the names so that each is in a specific position so that it always matches the text. See attached for that combined with the random X offset and semi-transparent colors. I've done this in a couple applications.

Re: How to make a scatter chart with x with discrete values ?

MarcoWedel — Wed, 26 Oct 2016 21:52:36 GMT

Maybe "Text in Chart" could be an alternative for the Name axis.

Another way to present this data might be a trellis scatter chart:

Using your example if I may.

hope this helps

regards

Marco

Re: How to make a scatter chart with x with discrete values ?

fredericvillemi — Thu, 27 Oct 2016 08:06:29 GMT

Thanks that's nice.

I had made an example with Treillis and it seems quite nice even if it is not what was requested.

With a mix of all the answers, I think I'll be able to make a very nice chart.

Thanks

Re: How to make a scatter chart with x with discrete values ?

fredericvillemi — Thu, 27 Oct 2016 08:06:44 GMT

Thanks, that's a very nice example. Great idea

Re: How to make a scatter chart with x with discrete values ?

Anonymous — Wed, 30 Nov 2016 03:49:17 GMT

Hi F, John and Macro,

I suppose I met a same problem as your.

Here is my raw data (Excel) and screenshot for my expected output.

X axis is model, Y axis is price, bubble stands for version and size of bubble stand for mix.

Very Appreciate!! @ John Witherspoon @ Marco Wedel