19 May 2022 The Qlik Wildmatch() function The Qlik WildMatch() function is an excellent and flexible way to check if a string contains one or more particular substrings. This post explains how it works. Friday Qlik Test Prep Functions Solution
12 May 2022 Using the subset ratio in Qlik to spot errors in key fields The subset ratio is a useful tool to spot errors in key field associations in Qlik Sense and QlikView. See how it works, illustrated with an example. Data Model Friday Qlik Test Prep Solution
4 May 2022 What’s the difference between Peek() and Previous() in Qlik Sense? Do you know the difference between the Peek() and Previous() functions in Qlik Sense and QlikView? They’re very similar, so people often mix them up. Read on to learn what the differences are. Friday Qlik Test Prep Functions Qlik Solution
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