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 »

Intro to Qlik Sense Mashups

Hi all, I’m Bernard, and in this post I will introduce myself to you and tell you more about the Qlik Sense API and Mashups. I would especially like to tell you why and when you’d use mashups instead of the ‘normal’ Qlik Sense dashboards.

First, a short introduction about myself, I’m Bernard de Bruin and I’ve been at Bitmetric since October 2017. Before starting as BI Consultant I studied Interactive Design, followed by a Digital Media and Communications study at the HU University of Applied Sciences. Here, I came into contact with the world of Business Intelligence when I did my minor in Big Data and Analytics. Seeing the interesting applications and potential, I decided to further pursue combining the disciplines of data, web development and interaction.

In my first blog at QlikFix, I want to show and tell your a little bit more about mashups and why you might want to use them. I will also show you an example of a simple mashup.

read more »

Tutorial Tuesday: Implementing version control for Qlik Sense with Git, GitHub and Visual Studio Code

Welcome to my second Blog post, which will be a basic tutorial of how to setup a lightweight version control for Qlik Sense script. This approach is straight forward to implement in various occasions. My aim is not to over complicate version control by offering this as a nice beginners guide on version control and workflow.

This tutorial will be part of a series of Tutorial Tuesdays that will lead to a lightweight, straight forward and easy to implement framework within Qlik Sense. In the series of tutorials hereafter will we cover topics as version control with script changes, different localization settings, loading centralized variables, creating master items on variables and eventually getting a simple dashboard up and running based on all tutorials altogether.

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 »

Qlik Sense Desktop February 2019 released!

Hi, I am Vincent Hayward and this is my first blog on QlikFix.com, okay well to be honest; it’s my first blog post ever. So let me introduce myself first as colleague of Barry Harmsen at Bitmetric. Furthermore I am working with QlikView since 2010 and before that I was a WebFocus consultant. But eventually you stick with the best, so QlikView and Qlik Sense it is and WebFocus at rest. To conclude this short introduction; I am 39 years old, living in Naaldwijk, The Netherlands with my wife and kids. Loves to play indoor soccer and videogames, such as Overwatch, Civilization, Red Dead Redemption 2, Diablo and Starcraft.

Qlik Sense has really made progress becoming a full scale product as QlikView and made a huge effort having certain features in Qlik Sense that were common in QlikView. At the end of 2018 with the November 2018 release we even got variable input, tabbed containers, buttons as a dashboard bundle package. Basically it was an extension package, which was added to the Qlik Sense Installer by default and who cares!?

With the february 2019 release they really vamped the look and feel with an improved flow within the application. Now we can move from data, analysis and story much better then before. It became an one click navigation element as a horizontal menu.

Data, Analysis and Story as a horizontal menu
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 »