Adding annotations to charts

By Barry Harmsen

Annotations in QlikView charts

I am currently at the Masters Summit for QlikView in San Francisco attending Bill Lay‘s session on QlikView data visualization. Besides hilarious delivery, Bill is showing some pretty cool visualization examples and tricks.

One thing Bill was showing are various ways you can add annotations to charts, putting them either on the axis or in the legend. One additional view that Bill and I discussed earlier is to put the annotations on the data point. Bill just asked me if there was a blog post about it. There wasn’t, but there is now. Not as polished as usual, but you’ll get the gist by looking at the QVW attached below.

Download the annotated chart example

About The Author

Barry Harmsen

Hi there, I'm Barry and I'm a Business Intelligence Consultant at Bitmetric and based in the Netherlands. Originally from a background of 'traditional' Data Warehousing, Business Intelligence and Performance Management, for the past few years I have been specializing in QlikView and a more user-centric form of BI. I have done numerous QlikView implementations in many different roles and industries. In 2012 I co-authored the book QlikView 11 for Developers. You can follow me on Twitter at @meneerharmsen.

8 Comments

  • 1
    Alan Farrell
    May 5, 2015 - 22:32 | Permalink

    And maybe a new video too! if you don’t mind that is?

  • 3
    May 6, 2015 - 11:37 | Permalink

    Very nice and simple solution!

  • 4
    May 6, 2015 - 20:09 | Permalink

    This can be solved also with a single expression :
    DUAL(IF(LEN(Annotation) > 0, Annotation & CHR(10) & ‘|’, ‘ ‘), SUM(Sales))

    • 5
      May 8, 2015 - 12:52 | Permalink

      Yes, that works as well. Dual() is great if you want to associate another text with your numbers.

  • 6
    May 11, 2015 - 02:13 | Permalink

    Yes, Dual was my solution for tagging the lines instead of using a legend:

    http://www.qliktips.com/2012/07/lose-legend-in-line-charts.html

  • 7
    Gabriel
    October 1, 2015 - 18:59 | Permalink

    Hi Barry,

    Thank you for this post.
    Unfortunately i am a user of Qlik Sense and so i am not able to open your example file…

    Have you got any idea of how to do it in Qlik Sense ?

    Thank you by advance,
    Gabriel.

  • 8
    Varsha
    August 1, 2016 - 08:03 | Permalink

    Oh great!
    Thank You 🙂

  • Leave a Reply

    Your email address will not be published. Required fields are marked *

    Read previous post:
    One Simple Trick That Will Significantly Boost Your QlikView Performance

    Edit April 2nd 2015: Yes, of course this is an April Fools joke, hope I made you smile. The Masters...

    Close