Category Archives: Script

Bitmetric Friday Qlik Test Prep – Week 12 – Automatic Concatenation

Every Friday at Bitmetric we’re posting a new Qlik certification practice question to our LinkedIn company page. Last Friday we asked the following Qlik Data Architect certification practice question:

read more »

Bitmetric Friday Qlik Test Prep – Week 10 – Unpivoting data – Solution

Every Friday at Bitmetric we’re posting a new Qlik certification practice question to our LinkedIn company page. Last Friday we asked the following Qlik Data Architect certification practice question:

read more »

Bitmetric Friday Qlik Test Prep – Week 6 – Looping tables – Solution

Every Friday at Bitmetric we’re posting a new Qlik certification practice question to our LinkedIn company page. Last Friday we asked the following Qlik Data Architect certification practice question:

read more »

Friday Qlik Test Prep – Week 2 – Section Access


Every Friday at Bitmetric we’re posting a new Qlik certification practice question to our LinkedIn company page. Last Friday we asked the following Qlik Data Architect certification practice question:

read more »

Friday Qlik Test Prep – Week 1 – Optimized Load

For the new year, we’re doing something new at Bitmetric. Each Friday, on our LinkedIn Company Page, we’ll share a test question that is representative of what you’ll find on the Qlik Business Analyst, Data Architect or System Administrator certification exams. Including the strange or vague wording that’s sometimes found in these exams 😉

We’ll follow up each Monday with the correct answer, as well as some additional explanation and insights. We hope this will help many of you prepare for your Qlik certifications, or at the very least provide a bit of fun and discussion.

read more »

Bitmetric Qlik Sense Coding Conventions – free download

At Bitmetric, we don’t believe in universal ‘best practices’. Which approach, standard or method works best should always be evaluated in the context of the environment. That being said, there are certainly starting points that can serve as ‘good ideas’.

Today we offer you one such starting point, the Bitmetric Coding Conventions for Qlik Sense.

Read on and find out how you can get your free copy of this document.

read more »

Implementing section access based on Qlik Sense user table.

Welcome to my third Blog post, which will be a basic tutorial of how to setup section access for your Qlik Sense application, based on the Qlik Sense user table. This approach, created together with my colleague Martijn Olivier, is straight forward to implement in various occasions. My aim is not to over complicate it with all the extra possibilities that are possible. Also bear in mind that it should not substitute application level access based on security rules. This method describes how to implement section access within an application, based on a custom property assigned to a group of users.

read more »

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 »

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 »

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 »