15 June 2022 Aggregating data in Qlik Sense with the Aggr() function Aggregating data in Qlik Sense or QlikView with the Aggr() function can be a challenge. This article explains how it works with an example. Friday Qlik Test Prep Functions Performance Solution
8 June 2022 The difference between SET and LET in Qlik The LET and SET statements in Qlik Sense appear to do the same thing, but are actually very different. Do you know the difference? Read on for the answer. Friday Qlik Test Prep Script Solution
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