61 articles
This post explains the difference between literal values and search expressions in Qlik Set Analysis.
6 April 2022

Literal values vs search strings in Qlik Set Analysis

In Qlik Set Analysis, you can use both literal values and search strings to filter valies. In this post, you’ll learn about the difference between these two, and how they work.

Expressions Friday Qlik Test Prep Set Analysis Solution
Learn how to concatenate tables in Qlik Sense or QlikView, and what to look out for.
29 March 2022

Concatenating tables in Qlik Sense

Concatenating tables in Qlik can be tricky. Learn how to apply the Concatenate and NoConcatenate table prefixes, and avoid a very common gotcha!

Friday Qlik Test Prep Script Solution
Learn how to use the TOTAL qualifier in the Qlik Sum() function
21 March 2022

Qlik Sum() function TOTAL qualifier

The TOTAL qualifier in the Sum() function in Qlik lets you create subtotals across higher level dimensions. In this post we’ll show you how.

Expressions Friday Qlik Test Prep Solution
In this post we'll learn how to unpivot data in Qlik Sense or QlikView with the CrossTable prefix
14 March 2022

Unpivot data in Qlik with the CrossTable prefix

When loading budgets or spreadsheets into Qlik Sense, unpivoting data is frequently required. In this post we’ll learn how to unpivot data with the CrossTable prefix.

Data Model Friday Qlik Test Prep Script Solution
Learn more about fan and chasm traps in Qlik Sense and QlikView
28 February 2022

Fan and chasm traps in Qlik Sense

Sometimes associations in a data model may look right at first glance, but will yield strange results once you start working with it. In this post we’ll learn about fan and chasm traps in Qlik Sense and QlikView.

Data Model Friday Qlik Test Prep Solution

Stay up to date

Sign up to our newsletter and get the latest news delivered directly to your inbox!