Category Archives: General

General topics

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 »

Introducing a new author at QlikFix: Wesley Smit

Albert_Einstein

One of the reasons I started this blog in 2010 was not only to share what I know about QlikView, but also to expand my own knowledge and understanding of it. In my opinion, explaining concepts and solutions to others is a great way to identify areas of improvement for yourself.

Recently, I got a new colleague at my company; Wesley Smit. Wesley is a recent graduate of Business Economics and Organization Sciences from the VU University in the Netherlands. With this business-oriented background, Wesley has an excellent understanding of the what and why of Business Intelligence. Since joining Bitmetric as a Junior Business Intelligence Consultant, we’ve been bringing him up to speed on how to develop BI solutions. Of course, the main focus is on QlikView, but we’re also working on peripheral solutions, methods and techniques that will make him an all-round consultant.

Wesley has been making great progress and is ready for the next step, not just gaining knowledge but also sharing it. In the coming time he will be posting articles on some of the things he has discovered while learning QlikView.

I welcome Wesley as a co-author on this blog and hope that you will enjoy his articles!

The power of QlikView caching

CacheToday I read a very interesting blog post about the QlikView Cache by Qlik’s Henric Cronström (HIC). In the post, Henric gives a high level overview of how caching is used within QlikView to speed up front-end response times. (for a more in-depth explanation, have a look at the patent) Henric also explains some interesting peculiarities about caching, one of which busts a myth that I hear repeated very often (“running macros clears the cache”). I highly encourage you to read Henric’s post.

Of course, this post isn’t just a me-too article. Rather, I want to show you a neat thing that will let you experience the power of caching in QlikView for yourself. Did you know that you can actually turn off caching?

read more »

Masters Summit for QlikView Europe: Amsterdam October 2014

AmsterdamBanner600

After successful events in Las Vegas, London and Barcelona, and the upcoming event in Chicago next April 1 – 3, I am pleased to announce that the next European edition of the Masters Summit for QlikView will be held in my hometown of Amsterdam, The Netherlands on October 1 – 3 2014.

If you are a QlikView developer then the practical skills, ready-to-use resources and excellent peer networking offered at this event will make for 3 days that you do not want to miss! More information about the event can be found on the Masters Summit for QlikView website.

TheGrandUpdate 2014/03/11: the date and venue have been finalized: 1 – 3 October 2014 at Hotel Sofitel Legend The Grand Amsterdam (Oudezijds Voorburgwal 197, Amsterdam 1012 EX, Netherlands).

You can register by clicking the button below:

RegisterNow

Scripts and wizards, too much script, not enough wizards

ScriptVsWizardsI recently read an interesting post by James Richardson over at the Business Discovery Blog: Wizards vs Scripts. In the post James makes the case that QlikView scripting is not old-fashioned or too hard, but is evidence of the power of QlikView as a platform.

Let me first state that I love QlikView scripting. I’m a guy who writes script for fun. I also agree that scripting offers much more flexibility than a visual solution ever could. With those things in mind, I would like to present a different viewpoint: I think that QlikView places too much emphasis on scripting. In my opinion, the default approach should be much more visual.

read more »