SenseTheme: Theme Builder for Qlik Sense


TL;DR: check out SenseTheme.

At Bitmetric, my colleagues and I regularly meet after work to investigate and experiment with interesting methods and technologies, share knowledge and generally shoot the breeze (we’re all at different client sites during the week, so it’s a good time to catch up).

The topic of our last meetup was Qlik Sense Themes. This is one of the big new (and highly anticipated) features in the Qlik Sense February 2018 release, allowing you to create custom themes for your apps. Our expectation was that we’d get the general idea of themes, go over the syntax and build a few cool themes. In reality, our meetup quickly devolved into a hunt for missing curly braces, property names and CSS classes. Still fun, if you’re into that sort of thing, but not as productive as we’d hoped.

read more »

Qlik named a leader in the 2018 Magic Quadrant

Qlik has been named a Leader in the 2018 Magic Quadrant for Business Intelligence and Analytics Platforms for the 8th consecutive year. Although Tableau and Microsoft seem to have expanded their lead, Qlik has made some excellent progress along the “Completeness of vision” axis. With all the cool stuff that is coming up in the next year, I am sure this will be followed next year by more success along the “Ability to execute” axis.

read more »

Qlik introduces Professional and Analyzer licenses for Qlik Sense

Qlik announces Professional and Analyzer licenses for Qlik Sense

As of today, Qlik has changed to a new licensing model for Qlik Sense. To those of you who’ve been around the Qlik ecosystem a little longer, this change will sound very familiar. Read on for a short summary of the most interesting changes.

read more »

Meltdown & Spectre impact on Qlik products

Meltdown and Spectre are two vulnerabilities disclosed in early 2018 that affect nearly every processor manufactured in the last 20 years. The initial assessment was that patching these vulnerabilities could in some cases lead to a 30% performance decrease on server workloads. Those are very serious numbers!

This may read like old news, but new patches have become available and some recommendations have changed. It is a good idea to regularly check up on these issues and avoid further problems.

read more »

Masters Summit for Qlik coming to Prague

The Masters Summit for Qlik is coming to Prague from April 3 to 5. If you’ve read this blog before, you probably have a good idea of what it is about: we’re going to take your Qlik skills to the next level!

For those of you that want to join us, but need to nudge the internal approval process a little bit, I have prepared a short presentation. This presentation lays out the event, content, speakers and, most importantly, the value to you and your organization.

Masters Summit Prague


Want to download/share the PDF version of this presentation? You can find it here. Looking forward to meeting you in Prague!

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 »