topic Re: Scatter Chart with 'Text' as X axis in QlikView

Scatter Chart with 'Text' as X axis

mellerbeck — Fri, 23 Jan 2015 22:40:11 GMT

If I have a scatter chart that I want say customer name as the X axis can you do this? It works with a numeric value, but when I switch the expression to a measure that contains Text it gives me a 'No data to display'

I tried an aggregate such as ONLY, MAXSTRING, but no joy.

Re: Scatter Chart with 'Text' as X axis

marcus_sommer — Sat, 24 Jan 2015 17:47:52 GMT

I think it would be rather not possible and you will need a kind of workaround with several objects which adding eachother or are overlapping or similar like suggested here: http://community.qlik.com/message/699205#699205.

- Marcus

Re: Scatter Chart with 'Text' as X axis

MarcoWedel — Sat, 24 Jan 2015 23:05:55 GMT

As the point about scatter plots is continuous axes, and you are looking for discrete x values, you should consider using another chart type.

Maybe a matrix chart would be the solution or a line chart showing dots or circles instead of lines.

Hope this helps

Regards

Marco

Re: Scatter Chart with 'Text' as X axis

mellerbeck — Mon, 26 Jan 2015 19:39:10 GMT

Line chart with symbols did the trick, thank you!

Re: Scatter Chart with 'Text' as X axis

Anonymous — Wed, 30 Nov 2016 03:55:07 GMT

But my question is how to show the size of circle?

I want to show the bubble chart.