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 10 years I have been specializing in Qlik and a more user-centric form of BI. I have done numerous QlikView and Qlik Sense 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.

Auto AutoNumber your key fields

A quick note on a cool feature that I recently learned from Oleg Troyansky: AutoNumber.

I hear you thinking: “What? You didn’t know about AutoNumber? It’s been around for years. Hand over your Luminary badge!“. Admittedly, this is also what I thought when I hear Oleg mention it but it turned out that I misunderstood. Oleg wasn’t talking about the AutoNumber() script function, but the AutoNumber script statement. This statement was added in the June 2018 release of Qlik Sense (as well as QlikView 12.20) and lets you AutoNumber multiple fields, across multiple tables in a single line of script. And no, despite it being available for over a year, I hadn’t heard about it before. I’ll certainly be using it going forward though!

read more »

Qlik named a leader again in the 2019 Magic Quadrant

Qlik has been named a Leader in the 2019 Magic Quadrant for Business Intelligence and Analytics Platforms for the 9th consecutive year! More information and a write up by Qlik’s Dan Sommer can be found here. The full report can be requested here.

read more »

Season’s greetings!

SenseTheme Christmas 2018 theme

Season’s greetings from QlikFix / Bitmetric! Just a quick little post to direct your attention to the SenseTheme Gallery, where we’ve just added a Christmas 2018 theme by our colleague Gwenny Sonneville.

And since we like being prepared, our colleague Bernard de Bruin has already created additional themes for winter, spring and summer 😉

Wishing all of you happy holidays and all the best for the new year!

For those of your who are interested in that sort of thing, below you can find some stats on SenseTheme usage in 2018

read more »

SenseTheme: Theme Builder for Qlik Sense

SenseTheme

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 »

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!).