26 April 2022 Splitting strings with the Qlik SubField() function Do you want to split a string in Qlik Sense based on a common delimiter? The SubField() function has the answer. This article shows you how it works. Friday Qlik Test Prep Functions Qlik Solution
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
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
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
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