21 april 2022 Getting the first value in Qlik with FirstSortedValue() The FirstSortedValue() function in Qlik returns the first (or second) value from one field, sorted on another field. For example, the first Employee ID by Contact Date. Friday Qlik Test Prep Functions Qlik Script
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
29 maart 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
14 maart 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
7 maart 2022 The Qlik debugger, breakpoints, comments and statements The Qlik Debugger lets you set breakpoints where you can pause the execution of your script. This post explains how the debugger works and how to properly set breakpoints. Friday Qlik Test Prep Script Solution
14 februari 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