62 articles
Learn about the Date() formatting function and the Date#() interpretation function, and what is the difference.
14 April 2022

Date formatting and interpretation functions in Qlik

Date() and Date#() are very similar looking functions. However, they both serve very different purposes. Learn how to interpret and format dates in this post.

Expressions Friday Qlik Test Prep Script Solution
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

Stay up to date

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