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.

Have QlikView – Will Travel. Where do Masters Summit attendees come from?

Advanced QlikView Training: theMasters Summit for QlikViewIf you are a regular reader of this blog, you are probably aware of the Masters Summit for QlikView. Besides offering some of the best advanced QlikView training available on the market, this 3 day event adds a unique “conference feel” where you are able to network and exchange ideas with peers from all around the world.

My colleague Frédérique recently put together some visualizations to answer some questions we had about our attendees; where do our attendees come from? How far do they travel? What kind of companies do they work for? Do they and their companies experience enough value to return?

As I thought you might enjoy these visualizations as well I have posted them to the blog. If you want to hear more about our attendees’ experiencing, be sure to also check out the testimonials page over on the Masters Summit website.

read more »

“Art” in QlikView, now in color!

Mona Lisa in QlikView - Oh no the horror, it's only black and white!!!! Save us MicroStrategy!!!!! ;)I came across this post on the MicroStrategy Community tonight. It mentions a few of the Qlik and Tableau visualizations of famous paintings that floated around a few years ago. The images that were used back then, an example shown on the right, were black and white. Robert, the author of the MicroStrategy article, concludes that black and white is boring, and that it would be much better if the pictures were in color.

MicroStrategy to the rescue! Robert writes that as of version 10, you are able to do colored visualizations in MicroStrategy. He then goes on to demonstrate a few visualizations in color! Take that QlikView and Tableau!

Overwhelmed by this spectacle of colors, I was already considering dropping my career in QlikView and moving into MicroStrategy when a thought popped into my head. Could it be that the author was mistaking the limitations of the data set (which only contained black & white values) for limitations of the tools? Perhaps QlikView (and Tableau) could also visualize pictures in color?

read more »

Win a free QlikView course for only a minute of your time (really!)

what-will-you-learn-todayv2_189As you may have read here before, besides blogging at QlikFix I also participate in the Q-On Training Center. Q-On offers focused, online instructor-led trainings that dive deep into specific QlikView and Qlik Sense subjects. These courses are delivered by well-known experts such as Rob Wunderlich, Karl Pover and Ralf Becher.

You can imagine that with attendees and trainers located all around the world, scheduling these courses so that it works out for everyone is sometimes not an easy feat. Besides that we are also developing additional courses.

Great, but you said something about a free QlikView course?

Yes, in order to better tune our courses to meet your schedules and interests, I have prepared a very short survey to ask you about your preferences. This will only take a minute of your time and in return you will be entered into a prize draw for a free Q-On training of your choice. The winner will be announced on July 1st 2015.

Looking forward to your input: take the survey.

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: