Category Archives: Expressions

Bitmetric Friday Qlik Test Prep – Week 17 – Peek() vs Previous()

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 16 – SubField()

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 15 – FirstSortedValue()

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 14 – Set Analysis: Literal vs Search strings

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 13 – Set Analysis: Literal vs Search strings

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 11 – Sum(TOTAL) – 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 5 – Set Analysis – 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 Business Analyst certification practice question:

No alt text provided for this image

There was a little catch to this question, which fooled exactly no one 😉

read more »

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 »

QlikView functions – a few to spice up your front-end!

Hello all! It’s been a while since my last post, so here I am trying to catch up with you guys again…

In the pastfunctions 2 few months, I came across a couple of functions which I hadn’t used before. Discussing these with Barry, he mentioned that Rob Wunderlich has done a Survey among QlikView Developers and created a list with functions and the frequency of them being used. Looking at that list, I will try to clarify what some of the functions do in a clear and easy example. Also, I will – hopefully together with you – try to figure out why the hack they’re positioned that low!

read more »

Introduction to alternate states

QlikView Alternate StatesA little while ago, I was asked to change an existing QlikView Application. While scanning the application, I found that it used Alternate States. I had already heard about Alternate States, and that they could store different user selections, but didn’t have any hands-on experience yet. I decided to dig a bit deeper into the subject before continuing. I wrote down what I learned in this post

read more »