QlikView for Developers: Update

QlikView for DevelopersToday PacktPub published a new version of Miguel García’s and my 2012 book, QlikView 11 for Developers. Now released under the version-agnostic title QlikView for Developers, the book can be used for QlikView 11, 11.2, 12 and 12.1. (and given how little love Qlik has shown QlikView recently, probably every upcoming version, if any, after this)

If you own the previous version of the book, and are still on QlikView, you may be wondering “Do I need to get this updated version?“. The answer to that question is “Unless you are a book collector, probably not“.

There are some things about the previous edition of the book that irk me. There are also many things that I have learned since 2012 and would do differently nowadays. Besides the irks, none of these things are in the updated version.

read more »

What I learned about Qlik Sense security

It's like a big wall, but for Qlik Sense, and it actually makes sense.When comparing Qlik Sense to QlikView, the most obvious differences are on the front-end, with its completely overhauled and fully responsive design. Other major differences are the server-based development, the use of Master Items and the shift towards APIs, mashups, extensions and widgets.

Somewhat less prominent, though very deserving of your attention, is the security model in Qlik Sense. This has a completely new approach compared to QlikView, and you can pretty much create endless variations. Rather than hacking stuff together and hoping it works, my colleague Rik and I recently decided to take a more structured approach and do some R&D on Sense security rules. Our goal was to gain more understanding of security in Sense, develop methods for gathering and modeling security requirements and to design reference patterns for common implementation scenarios.

We will be sharing some of the methods and patterns that we came up with in an upcoming white paper. In the mean time, I’d like to share with you some of the little interesting, strange and otherwise noteworthy things that we found. These range from basic to slightly obscure, but all should hopefully help you get more understanding of Qlik Sense security rules. Let’s start with noting that the approach in Sense is totally different than it was in QlikView…

read more »

Qlik named leader in the Gartner Magic Quadrant

The 2017 Magic Quadrant for Business Intelligence and Analytics Platforms has been released and Qlik is in the Leaders quadrant for the 7th consecutive year! Besides Qlik, both Tableau and Microsoft return in the Leaders quadrant, where they also were last year.


Comparing this edition with previous year’s Magic Quadrant, we can see that Qlik has lost around 15% on Completeness of vision, while more or less keeping the same Ability to execute. At the same time, we can see that both Tableau and Microsoft have both significantly improved their lead in these areas. I haven’t seen the actual analyst report yet so the reasons for these changes remain speculation at this time.  (will update with a link once a vendor releases it for free).

Update 2017/02/22: the full report can be found here.



Looking at the multi-year trend, we can see that Business Discovery has truly become mainstream while the previously dominant ‘Mega Vendors’ have been downgraded to the middle of the pack (look where IBM was in 2013, and where it is now). The positive exception here is Microsoft, which seems to have reinvented themselves in the past few year (Power BI!).


Look who’s talking to your Qlik Sense Desktop

lookwhostalkingHappy new year to you! Just a very short post today with a little fun and possibly a warning. You may be aware that you can use the Qlik Sense API’s on your Qlik Sense Desktop, but are you also aware that any webpage can access them? The widget on the top right contains some JavaScript that tries to connect to your local Qlik Sense Desktop, if it succeeds the version and number of apps are displayed. (click on the X Applications link for an application browser)

This is just some harmless fun of course, and potentially offers some nice options for Qlik bloggers, for example click to automatically generate an app, online performance analyzer, etc. Just be aware that there could also be more nefarious purposes, for example deleting applications or extracting data. It’s probably very unlikely that someone will target this, but good to keep in mind anyway.

On a different note, Qlik Sense 3.1 SR4 was released yesterday. And, if you’re based in The Netherlands (or willing to travel there) and interested in Qlik Sense web development with mashups, extensions and widgets then we have an interesting training coming up. More info here (in Dutch, but training will be in English, contact me if you’re interested).

Handling multiple languages and translations

Handling multiple languages and translations in QlikViewRecently I made a QlikView application with multiple languages. I came across a blog post by Charles Bannon: “Handling multiple languages”. Charles describes two scenarios for the use of multiple languages. The first scenario, “translate labels and textboxes within the application and not the actual data”, solved my problem. Charles uses a translation table with an index. He uses set analysis to reference the index number and the language. The expression used is:

=Only({<Index={5}>} [$(=vDataLanguage)])

A good solution, but not very user-friendly. Do you know which translation belongs to index 5?

In this blog post I will rewrite the expression to a more user-friendly and readable formula, and will also explore some other ways of dealing with translations in QlikView.

read more »

A very elegant link table script

Some nice out of the box thinkingToday was the last day of the Masters Summit for Qlik in Johannesburg and we all had a great time. One of the things I very much enjoy about these events is the chance to speak with so many experienced people who are enthusiastic about Qlik and keen to share their knowledge. I always go home with some cool new tricks and insights.

What I want to share with you today is an alternative script for building a link table. This was shared with me by Rene McGregor and the nice folks over at QlikView South Africa (who have also been very supportive in bringing the Masters Summit to South Africa, much appreciated).

read more »

Event tip: Dutch Information Visualization Event 2016

Dutch Information Visualization Event 2016

Quick event tip: are you based in the Netherlands and interested in (tool agnostic) Data Visualization? If so, check out the Dutch Information Visualization Event (DIVE 2016) on June 23rd in Utrecht. More information (in Dutch) can be found here.

Thoma Bravo acquires Qlik for 3 billion USD


Those who have been following the news around Qlik (the company) lately have probably noticed that something’s been stirring the past few months. It started in March with activist hedge fund Elliott Management disclosed that it had bought a significant stake in the company. Later that month, Elliott raised its share even further and began pushing for a sale of the company. Potential buyers that were named at that time were IBM or Oracle, neither of which seem like attractive alternatives to me.

It became clear to me that a sale was at least considered as an option by Qlik when I saw the updated the severance packages for tier 1 to 3 executives on Qlik’s Investor Relations page on April 1. Meanwhile, rumors about a potential sale were everywhere. Rumors are just rumors of course, but where there’s smoke…

Then things got quiet for a while, until June 1, when the news appeared that private equity firm Thoma Bravo had submitted a 2.8 billion USD bid on Qlik. And today, June 2, things came to a conclusion when it was announced that Thoma Bravo has acquired Qlik for 3 billion USD.

Of course, for Qlik customers, partners and us developers that raises some questions, and maybe even concerns. I decided to put some of my thoughts in this blog post.

read more »

Extracting embedded images from QlikView

ImageExtractor for QlikView

ImageExtractor for QlikView

ImageExtractor is a small utility that extracts images from your QlikView applications and stores them as bitmaps. It also gives you a browser that tells you which images are used in which QlikView application.

read more »

Masters Summit Milan recap

Last week the Masters Summit for Qlik was held in Milan, Italy. For those unfamiliar with the event, the Masters Summit is a 3 day advanced training for QlikView and Sense developers. If you have followed all the Qlik trainings (Designer, Developer, etc.), have 1 to 3 years of experience and ask yourself “Now what?” then this training is perfect for you.

I was at the Masters Summit and presented two sessions, Data Modeling and Server/Publisher Administration. In this post I will share with you some of the experiences and feedback from the event.

81 Qlik enthusiasts participated in this edition and as you can see in the photo below, we were at full capacity.

A packed house!

read more »