Author Archives: Barry Harmsen

Barry Harmsen

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.

RightQlik: a Windows Explorer context menu for QlikView

RightQlik

RightQlik is a small utility written by QlikView 11 for Developers co-author Miguel García. As I love how this utility makes my developer life just a little easier I posted a link today on LinkedIn and Twitter. I was surprised by how many people had never heard of RightQlik. It’s been out for quite a while. In the hope of having a few more people discover this little gem I am putting this post on my blog.

So what does RightQlik do?

RightQlik is a custom context menu (pictured right) that is shown when right-clicking on a QVW file. It allows quick access to common functions that you will often perform on a QlikView document:

  • Open in a new QV instance: open the QlikView document in a new QlikView instance (i.e. “having the program open multiple times”). This lets you easily switch between several QlikView files, or display them side by side (this is what I often use).
  • Open without data: opens the document without also loading its data. Very useful when you quickly need something from a big document, or if the data has become corrupted (fortunately a very rare event).
  • Reload document: reload the QlikView script and close the document after completion. With this option, you can run simultaneous, local reloads of several QlikView documents with a simple click by first selecting all of them.
  • Reload and keep open: reload the QlikView script and keep the document open after completion.

This custom context menu is only shown when dealing with QVW files, so it will stay out of your way when dealing with any other file type.

You can download RightQlik for free from the QlikMarket.

PS. If you find this utility useful, then please consider writing a short review on the QlikMarket.

Qlik Sense voice control with Amazon Echo

Amazon EchoI am currently at the Masters Summit for QlikView in San Francisco, where I just got a really cool demo from Rob Wunderlich. Rob built an extension object that integrates with Amazon Echo (want!) and allows you to control Qlik Sense using voice commands. Check out the video below.

Just as a reminder, if you weren’t able to join us at the Masters Summit in San Francisco this time, we have upcoming events in New York City and Copenhagen later this year. Check out the website for more information.

Adding annotations to charts

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

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 Summit is no joke though, and neither is the $300 early bird discount that you will receive until April 15th 2015. Want to really take your skills to the next level? Join us in San Francisco on May 4 – 6, or New York City or Copenhagen later this year.

Amazing Business DiscoveriesToday I am going to let you in on a big secret.

People often ask me how I always get great performance and fast response times out of my QlikView applications. I usually put on a very serious face and reply that this is the result of years of experience. Experience gained by doing hundreds of implementations, practice, experiment, study and continually refining my skills and knowledge.

You won’t believe how hard it is to not burst out laughing when I tell this to people. The fact of the matter is that it is all a gimmick!

There is only one simple trick that you need to know to instantly boost your QlikView performance. This is the secret that Qlik and the Qlik Illuminati don’t want you to know, but today I will reveal it all!

Are you ready for the truth? Here it comes!

read more »

What QlikView developers can learn from The Karate Kid

Karate KidAs you might have guessed from some of my earlier posts, I am a sucker for popular culture from the 80’s and 90’s. On this (apparently) most-depressing day of the year, let me offer you some light hearted, positive reading and share with you five of the motivational lessons that I learned from the 1984 classic The Karate Kid. Specifically, I will tell you how these lessons can be applied to learning QlikView, increasing your skills and expanding your knowledge. Or at least make you smile.

A quick summary of the plot for those not familiar with the movie (shame on you! 😉 ):

Daniel has just moved from New Jersey to California with his mom. He quickly discovers that it isn’t as great as he thought it would be. Daniel doesn’t fit in and a gang of bullies, who are all adept at karate, are making his life miserable. He then meets Mr. Myagi, a handyman who also happens to be a karate master. Mr. Myagi takes Daniel under his wing and teaches him karate, showing him along the way that karate (and life) are not always about power and strenght. Can Daniel overcome his bullies in the All-Valley Karate Championship? (spoiler: yes he can!)

And now, on to the lessons!

read more »

Online QlikView trainings in January 2015

As you may know, we offer online QlikView and Qlik Sense trainings through the QlikOn Training Center. These trainings are short (4 hours max), instructor-led and focus on a single subject which will be covered in-depth. With small groups there is enough opportunity to ask as many questions as you like. A perfect way to increase your skills and knowledge.

For January 2015, we are offer the following trainings:

4ac7eff2-df02-466d-ba70-58a779a6d3e6Introduction to QlikView Extensions
Date: Thursday January 15th
Duration: 2.5 hours (2 sessions)
Trainer: Ralf Becher

 

b8183d29-3f2f-4f7c-a7c4-995e2c6f5d9cQlikView Components Scripting Library

Date: Thursday January 29th
Duration: 3.5 hours (1 session)
Trainer: Rob Wunderlich

 

0b72d2c1-a3d8-4183-8d85-d2442814940aQlikView Data Visualization (new)

Date: Friday January 30th
Duration: 4 hours (1 session)
Trainer: Karl Pover

 

95eb1483-6067-47f7-9ef5-27d358ca7af2Set Analysis

Date: Thursday January 22nd
Duration: 4 hours (2 sessions)
Trainer: Barry Harmsen

 

For more information check out the QlikOn website. Are you in need of a specific training, or do you have an interesting QlikView / Qlik Sense training that you would like to deliver? Feel free to contact me to discuss.

Visual FX in QlikView (5): Merry Xmas 2014!

Christmas time is near again, so it’s time for another visual effect in QlikView: the QlikFix 2014 Christmas Card. Using the trusty animated scatter plot once more, I’ve built a little spinning Christmas tree (and, in the spirit of Christmas, added some awful music 😉 ). Check the video below:

The complete QVW can be downloaded below:

Download the 2014 QlikFix Christmas Card

Wishing you all happy holidays and all the best for 2015!

More visual FX in QlikView:

 

New feature: QlikView / Qlik Sense book list

Books for QlikView and Qlik Sense developers and consultantsDifferent people have different preferences for acquiring new skills and knowledge. Some like to follow a classroom training while others prefer to start with a concrete problem, research the subject themselves and learn by doing. Some people like to read blog posts and watch videos, while others prefer to read a book. Today I have something for that last group; a reading list for QlikView and Qlik Sense professionals.

The reading list is available through this link, or via the top menu bar. It does not only contain books about QlikView or Qlik Sense, but also a range of peripheral methods, skills and technologies that I believe will make you a more well-rounded Qlik professional. I will be periodically updating this list with new and relevant books.

I hope you will enjoy this list. If there are any must-read books that you are missing, feel free to contact me through the contact form, or leave me a comment below.

Remove scrolling tabs from QlikView Chart Properties

Remove scrolling tabs from QlikView Chart Properties

A short post today, but one that will fix a very common developer annoyance in QlikView 11 and 11.2; the scroll tabs in the chart properties dialog window. When you want to change properties on tabs that are on opposing sides of the tab row (for example, Dimensions and then Layout) you first have to click the scroll arrows before you can select the tab. Extremely annoying, if you ask me.

read more »

Masters Summit early-bird offer ends this week

Masters Summit for QlikView - Amsterdam

A quick heads-up for those of you who are planning to attend the upcoming Masters Summit for QlikView in Amsterdam, the early-bird offer ends this Friday, August 15th. Don’t miss out on a $300 discount!

For more information about the event, or to register, please go to the Masters Summit for QlikView website. I hope to meet many of you there!