19 October 2022 Qlik subset load with SAMPLE and FIRST Learn more about how to create data sub sets within the Qlik load script using the FIRST and SAMPLE prefixes. This post also goes into detail on when to use which, and what happens when you combine both. Friday Qlik Test Prep Solution
13 October 2022 Qlik variable scope in subroutines Learn more about Qlik variable scope in subroutines, and why it matters for returning values from your Qlik subroutines. Friday Qlik Test Prep Script Solution
5 October 2022 Qlik Set Analysis – Outer Set Expressions Qlik Sense and QlikView now have a new Set Analysis syntax: Outer Sets. This makes it much easier to reuse Set expressions and Master Measures. Learn how it works in this post. Friday Qlik Test Prep Set Analysis Solution
28 September 2022 Qlik subroutine parameters – passing arguments by reference and by value This post explains the important difference between passing by value and passing by reference when using parameters in Qlik Sense subroutines. Friday Qlik Test Prep Script Solution
21 September 2022 Qlik Autonumber pitfalls The AutoNumber function in Qlik is very useful to create compact keys, but also comes with some pitfalls. Learn what to avoid in this post. Friday Qlik Test Prep Script Solution
14 September 2022 Using KEEP and JOIN in Qlik Sense How to use KEEP and JOIN in Qlik Sense to reduce the number of rows in already loaded tables. The example shows how to keep only the max value. Data Model Friday Qlik Test Prep Script Solution