Qlik Community

Ask a Question

Qlik Design Blog

All about product and Qlik solutions: scripting, data modeling, visual design, extensions, best practices, etc.

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
marthacano01
Partner
Partner

Thanks, very nice post!

0 Likes
2,648 Views
Not applicable

Very Use full

Thanks to share

0 Likes
2,648 Views
thanstad
Creator
Creator

NIce feature has become a standardobject in our company. Now we make the same on Barchart aswell.

/tormod

0 Likes
2,648 Views
a5123283
Contributor III
Contributor III

Great work here fellow QV peers!

I trying to bring it up another level by doing it on stack charts using % type of aggregation. Does anyone know what will be the coding for each expression background?

2.jpg

I have tried this coding on the background but it is not working:

=if(match([Macro Region],concat(distinct [Macro Region],',')),Green(),ARGB(150,225,225,225))

Expression:

$(vOnTimePercent):

(Sum (If(AllocationDateCode - ShipDateCode <= 0 or [Allocation Date] = 'In Stock',[Gross Value Open CAD])))

/

Sum (If(([Allocation Date] <> 'Season Open for Preseasons'

and [Allocation Date] <> 'Not Set'

and [Allocation Date] <> 'RTP'

and [Allocation Date] <> 'RTS'),

[Gross Value Open CAD]))

1.jpg

Sample app can be downloaded fro here.

Qlik Demos: See QlikView in Action | Demo.Qlik.Com

Regards,

Nelson

0 Likes
2,648 Views
joydipp1988
Creator
Creator

Hi amz‌,

Really amaizing post. I learned a lot. Thanks for sharing.

I was trying to apply the same in Fill Line Chart. But its not working. Here is the snap-

Fill chart.PNG

But its working fine with simple line chart. Here is the snap-

Simple Line chart.PNG

Please guide me how to achieve the same in Fill Line chart.

Thanks in advance.

Regards,

Joy

0 Likes
2,635 Views
stevedark
Luminary Alumni
Luminary Alumni

Hi Joydip,


I think I've seen this question come up before - and the quick answer was that it couldn't be done.

Steve

0 Likes
2,635 Views
felixobes
Contributor III
Contributor III

This is a great explainer!!

0 Likes
1,445 Views