89 articles
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
What sort of value does the MonthEnd function in Qlik return? Is it a date? Read on!
21 February 2022

What’s the value of the Qlik MonthEnd() function?

Do you know what type of value the Qlik MonthEnd() function returns? Is it a date? Or might it be something else? This post offers an in-depth explanation.

Friday Qlik Test Prep Functions Solution
Looping tables in Qlik can be tricky. Learn about indexes and how dropping tables affects them.
14 February 2022

Qlik table functions and indexes

Learn about table functions and indexes in Qlik and how dropping tables affects the indexes of the remaining tables.

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!