Monthly Archives: September 2019

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 »