22 June 2022 Using the GROUP BY clause in Qlik Sense When using aggregation functions in Qlik script we often need to use the GROUP BY clause to define on which level the data should be calculated. This article shows you how. Friday Qlik Test Prep Performance Script Solution
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