topic Re: Lines between data points on Scatter Graph in App Development

Lines between data points on Scatter Graph

stevedark — Mon, 07 Mar 2016 14:36:24 GMT

Hi,

In QlikView it is really quite simple to add a dimension to a scatter graph such that the position of points is plotted for the beginning and the end of a date range and then have a line drawn between the two points. By altering the size of the bubble based on whether the date dim is at the start or the end, you can make it clear which value is where the historical value is and which is the most recent. The line then gives an excellent indication of which direction a particular point is moving in.

I'm trying to recreate one of these charts in Qlik Sense, and as far as I can see it is not possible to add more than one dimension to the stock Scatter Graph.

Does anyone know of a way that I can create the visualisation like it was in QlikView?

Thanks in advance for any assistance you can give.

Steve

Re: Lines between data points on Scatter Graph

stevedark — Thu, 07 Apr 2016 13:39:24 GMT

Does anyone have a view on this, perhaps mto‌ or jgd‌ ?

Steve

Re: Lines between data points on Scatter Graph

Josh_Good — Fri, 29 Apr 2016 22:44:18 GMT

Hi Steve,

Connecting points in scatter plot isn't exactly a visualisation best practice so I don't believe you can do this with Qlik Sense. That said I do understand the utility of what you are trying to do.

In Qlik Sense, I was able to get close to what I believe you are trying to do but I couldn't draw a line connecting the points.

Josh

Qlik

Re: Lines between data points on Scatter Graph

stevedark — Fri, 29 Apr 2016 23:35:15 GMT

Hi Josh,

Thanks for your thoughts on this.

The functionality that I am looking for is there in QlikView, and yes... I have seen some complete trainwrecks of charts, where data points have been plotted over many values, all joined with lines. It is impossible to tell what is going on from that.

However, with a second dimension that only has current state and prior state, and a translucent colour on the prior state, you can get a really good idea how your data points arrived at where they are. As well as knowing where something is, you get a feel for whether it is moving up or moving down.

Consider the following chart:

This is looking at 2015 vs. 2014 for a set of data (scale and legend excluded for obvious reasons).

The translucent grey bubbles are showing 2014, whilst the coloured in bubbles are 2015. You can see straight away where the points are, as well as where they were. The pink has shot up from where it was last year, whilst the yellow has improved on one axis but dropped on the other. There are also data points that only exist in 2014 (just grey dots) and some that only exist in 2015 (coloured dot, no line).

To my mind this is a very useful visualisation, and very easy to do in QlikView. It's a real shame that it is not possible in Sense yet.

Cheers,

Steve

Re: Lines between data points on Scatter Graph

Josh_Good — Sat, 30 Apr 2016 07:16:45 GMT

‌HI Steve,

Thanks for the image. Now I understand better and I definitely agree this type be viz is useful. To do it well I think an extension would be the best approach. However I was able to get close using the Qlik Sense scatter. My approach was to create a calculated dimension that concatenated my dimension (CategoryName) and Year. Once I did this I had a point for each CategoryName-Year combination. The next problem was to change the colour intensity so it was easy to see which points were the most recent. I got lazy and wrote a nasty if statement.

if(CategoryName = 'Babywear', RGB((Year-Min(total Year) )/ ( Max ( total Year) - Min (total Year)) *100+155,0,0),

RGB(0, (Year-Min(total Year) )/ ( Max ( total Year) - Min (total Year)) *100+155 ,0))

I wouldn't recommend this route but it does prove out that the colours for every point can be different based on the category and year. I imagine you could create a data with the R, G, and B number for each dimension (CategoryName in my case) and then just apply intensity factor.

The one thing I couldn't do is add a line between points. Anyway I hope this helps. Again an extension would likely be a better and more robust option but this approach does work.

-Josh

Qlik

Re: Lines between data points on Scatter Graph

stevedark — Sat, 30 Apr 2016 21:05:08 GMT

Hi Josh,

Many thanks for giving this some extra thought, and for sharing your example.

I'm already very familiar with nasty IF statements and dummy dimensions in Sense to get the colours required, as evidenced in this post on variance to target charts:

http://www.quickintelligence.co.uk/qlik-target-bar-chart/

Cheers,
Steve

Re: Lines between data points on Scatter Graph

Anonymous — Thu, 05 Jan 2017 17:20:07 GMT

Have you resolved your issue with Sense? with an extension?

I have the same problem, in some Qlikview apps I have several very useful scatter graph's with 2 dimensions.

Regards

Re: Lines between data points on Scatter Graph

stevedark — Thu, 05 Jan 2017 18:09:45 GMT

Hi Francisco,

I haven't yet found one that allows me to produce charts like the one I show above. A shame as that is a really useful visulaisation to show movement between two times.

Steve

Re: Lines between data points on Scatter Graph

odassier — Fri, 06 Jan 2017 07:38:58 GMT

Hi Steve,

Thank you for starting this post, I too have been looking for a solution to this in Qlik Sense. I work in Risk Management and the most common chart we use has Risk on the X-axis and Return on the Y-axis. It would be very useful to show how the portfolio's risk/return tradeoff changed from one period to the next. Ideally, I'd like to replicate a snail trail type of chart and be able to link not just two periods but multiple (e.g. 4-8 quarters) and show the evolution of the portfolio in risk-return space over that period.

While a line chart is best for this analysis on a single portfolio, I need to show several portfolios or markets and use a bubble chart to show where they stand today in comparison to each other where the size of the bubble is controlled by the market capitalization or $ value of the portfolio. At the very minimum, I'd like to do what you request here, and show the evolution of each portfolio or market since six months ago or a year ago, but a snail trail chart for multiple periods is really what I'm after.

Olivier

Re: Lines between data points on Scatter Graph

stevedark — Fri, 06 Jan 2017 08:12:35 GMT

Hi Olivier,

The QlikView chart does this out of the box. I just limited the one I screenshot above to show only the last two periods (using set analysis) as the chart does get quite cluttered if there are too many grey dots leading up to the coloured one. You could have in the logic that the number of periods shown varies based on the number of visible dimensions, so if you are looking at a single portfolio full history is shown as a trail, 2 - 5 portfolios show four periods and then only the one prior period if more portfolios are visible.

All quite simple in QlikView.

What would make a killer Qlik Sense extension is a library where you could create the charts that where available in QlikView in Qlik Sense. This is not just me hankering back for the 'good old days' [1], but there are some really nice features in some of the QlikView chart types that I have not yet found extensions for.

Steve

[1] Okay, it is a bit.

Re: Lines between data points on Scatter Graph

odassier — Fri, 06 Jan 2017 09:20:21 GMT

HI Steve,

Thanks for sharing. I am using Qlik Sense though, and not QlikView so was looking for what you did in the latter part of your response, a way to implement this in Qlik Sense.

Thank you for sharing your knowledge, though, I am just beginning to use Qlik Sense and it’s a steep learning curve!

Olivier

Re: Lines between data points on Scatter Graph

stevedark — Tue, 28 Feb 2017 14:15:23 GMT

It is looking like this extension from the guys at VizLib ( ack‌ mahlerma‌ and anguila2‌ ) could be the answer.

Vizlib Scatter Plot for Qlik Sense

I need to do a lot more playing with it yet though.

Steve

Re: Lines between data points on Scatter Graph

odassier — Wed, 01 Mar 2017 01:02:43 GMT

HI Steve,

This is perfect, exactly what I needed! Thank you so much for sharing. Will play around with it but based on their example, this should do the trick.

Olivier

Re: Lines between data points on Scatter Graph

stevedark — Fri, 03 Mar 2017 22:06:28 GMT

Thanks Olivier. You may also want to see the blog post I've done on the VizLib extensions, which has a bit more detail on where they may go next: http://bit.ly/2mBkCmb‌

Steve

Re: Lines between data points on Scatter Graph

odassier — Sat, 04 Mar 2017 03:00:07 GMT

Hi Steve,

Great blog post, thanks for sharing. I hadn’t heard about Rosling’s passing either. His videos are what turned me onto visualization in the first place. Will follow the Vizlib team.

If I may, I’m still stuck on the second scatter plot, not seeing the time line. Could you figure out what I’m doing wrong? The first one worked so well.

Thanks,

Olivier

Re: Lines between data points on Scatter Graph

stevedark — Mon, 06 Mar 2017 08:55:55 GMT

Hi Olivier,

I believe that the VizLib guys have been in touch with you and given pointers in what you need to do to make this work? They are looking at making more dates and formats work in future.

Re: Lines between data points on Scatter Graph

odassier — Mon, 06 Mar 2017 08:58:05 GMT

Yes, sorry, they have. I sent them the underlying data and Hope they can help.

Cheers,

Olivier

Re: Lines between data points on Scatter Graph

simondachstr — Sun, 12 Mar 2017 17:34:38 GMT

Hey guys -

We have added support for more dates & formats - this is now being tested internally and will be released probably the week after this week.

@Olivier - you should have received an answer from Vizlib regarding your questions.

Will keep you updated here as well when we update our chart.

Thanks,

Martin

http://www.vizlib.com

Re: Lines between data points on Scatter Graph

odassier — Mon, 13 Mar 2017 00:58:15 GMT

Hi Martin,

Yes, Vizlib got back to me and fixed all my issues. Great support and great extension. It will become a key part of my dashboards and allows me to combine both point-in-time analysis with time-line views in a single chart; very useful in finance.

Olivier

Re: Lines between data points on Scatter Graph

jimmygohhanjie — Tue, 10 Apr 2018 14:59:24 GMT

Hi stevedark‌

Nice chart, I am looking to create that. Still new to Qlikview.

The scatter chart with 2014 in grey and line link to 2015.

Do you have a guide or walk through to create that.