Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
ArturoMuñoz
Employee
Employee

Continuing the line charts topic I've started a few weeks ago, let see how to adjust a line chart to help us to see what we want to.

Displaying what is important

In the example below I want to display Sales evolution by store over time, but it happens that this company has too many stores (lines) to easily identify them individually in the chart.

I still can get some value out of this chart; global trend is still visible. Seems like sales are decreasing over time, but details are lost in the color mess.

6.png

As color is not helping me to better decode this chart, I will unify line colors.

7.png

8.png

Now I can see much better my company’s trend, sales amount is decreasing, based on the overlap of individual store behaviors but details are still hidden in green.

Selecting a store I could isolate it and get its details. This is great and fast, but it avoids me from seeing the selected store in context. What I would like to see is the sales evolution of particular store vs all others.

9.png

The next step will be to avoid the chart to be filtered out when a store name is selected, to do so I will include set analysis in my expression.

Original expression:  sum(Sales)

New expression:       sum({<Store=, [Store Name]=>} Sales)

By doing that my chart won’t be filtered by Store or Store Name selections

10.png

Now, what I need is to highlight the store within the chart. Again I will use the Background Color properties for the expression to achieve that.

11.png

if(isnull(only([Store Name])) ,ARGB(20,200,200,200),ARGB(190,43, 123, 70))


This expression will gray out all non-selected stores and highlight our selection(s).

12.png

13.png

With this new chart, my selections will help me to see store details and to keep selected store(s) in context. I can see the global trend and compare it with any store just by searching and selecting.

Extra tip:  If you look carefully at the two charts above, you may notice a slightly color difference in the second image dark green line, this is because the green line is under several semi-transparent gray lines making it look little bit different.
Sorting the dimension will help you to prevent this. In this case I’m sorting Store Name by sales amount using the following expression.

aggr(sum(Sales),[Store Name])

You can see this chart working as part of Retailer EPOS Data Analysis demo.

Line charts beyond your imagination

These are some creative and really cool non-standard uses of line charts I have seen lately:

Parallel Co-Ordinates Chart

14.png


This chart variation was firstly introduced by Alistair Eaves some time ago. The chart is great for showing data paths between various dimensions; letting people to understand something so hard to see as flows dynamics in the data. Check out the demo

Dynamic Network Flow Charts


15.png

If you are a frequent flyer you will probably have read all magazines in your front pocket. One of my favorites readings on board are these maps with all the routes airlines operate through the world. Matthew Crowther stretched out QlikView line chart object to display information in the same way but keeping the QV soul (association) in it. If you want to know how to do it, you should read: New Qlikview Chart Type: Dynamic Network Flow Charts | QVDesign

The Associated Curve Chart


16.png

Based on the same principles but pushing things a little bit more Matthew presented this new chart, he called Associated Curve Chart.  You can check it out at Matthew's blog

Enjoy Qliking!

AMZ

27 Comments
Anonymous
Not applicable

Thanks Arturo:

Very interesing and illustrative.

CB.

0 Likes
4,073 Views
kalyandg
Partner - Creator III
Partner - Creator III

hi Arturo,

Really very interesting post, also a good illustration.

0 Likes
4,073 Views
sudeepkm
Specialist III
Specialist III

wonderful, superb thnx a lot for sharing this knowledge.

0 Likes
4,073 Views
Not applicable

Hi Sir

Nice post !  i personally find line chart is one of the chart CEO like to see , Sales , Exp , Net profit chart by year. as this chart will be able to see how well the company perform.


i happen to have a chart which i am not able make the present more interesting. when i try to follow your step , i get stuck on bel;ow expression :-

sum({<Store=, [Store Name]=>} Sales)


From your above expression , i cannot figure out how you get the 2 field , Store and [Store Name]  , in my application , i only have one field that is [Store Name], i don't have Store field.

it is possible for you to post an example ?

Paul

0 Likes
4,073 Views
stevedark
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi Arturo - thanks for sharing - a good illustration of what can be achieved if you think outside of the box a bit.  Also a reminder about context, as James Richardson was talking about in his blog post on Ishiness:

http://community.qlik.com/blogs/theqlikviewblog/2013/11/08/ishiness-or-keeping-an-overall-sense-of-w...

In response to Paul's question I posted some thoughts over on another thread, regarding using an expression in the background colour code that would allow multiple rows to be shown highlighted against other transparent lines: How to make only selected line chart diff color from other ?

- Steve

4,073 Views
ThornOfCrowns
Specialist II
Specialist II

Great idea and implementation. I'll shamelessly plagerise be inspired by this when improving some of the 'data clutter' charts I have inherited!

4,073 Views
Jason_Michaelides
Luminary Alumni
Luminary Alumni

Very simple and effective - thanks .

3,458 Views
stevegimbrollmt
Creator II
Creator II

Great idea...and will be implemented in my dashboards ! thanks

3,458 Views
whiteline
Master II
Master II

Hi. Thanks for sharing!

Some thoughts:

Although it's just an example, it seems that the stores with higher sales are not so important than the others.

Or the chart points out that there are a lot of small sales at the bottom.

Alpha blending in such cases is much more powerful, can be used regardless of selection highlighting and often can lead to unexpected user experience.

3,458 Views
stevedark
Partner Ambassador/MVP
Partner Ambassador/MVP

Where I find blending particularly useful is on scatter charts - where

overlapping spots can give a nice heat map.

0 Likes
3,458 Views