29 June 2022 How to use the Lookup() function in Qlik Sense In this post we show you how to look up values from Qlik tables with the lookup function. You will also learn about the alternatives and the pros and cons of each approach. Friday Qlik Test Prep Functions Performance Solution
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