25 May 2022 Adjust timezones in Qlik with ConvertToLocalTime() Have you ever had to adjust timestamps in UTC time to your local timezone? Then ConvertToLocalTime() is just the function you need. This article explains how it works. Friday Qlik Test Prep Solution
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
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