3 augustus 2022 Using the GENERIC LOAD statement in Qlik Sense With the GENERIC LOAD statement in Qlik Sense you can pivot data from rows to separate columns. This post shows you how this works using an example. Data Model Friday Qlik Test Prep Script Solution
27 juli 2022 How do I join tables in Qlik Sense? Learn how to join tables in Qlik, and what the differences are between inner join, outer join, left join and right join. Data Model Friday Qlik Test Prep Script Solution
22 juni 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
8 juni 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
21 april 2022 Getting the first value in Qlik with FirstSortedValue() The FirstSortedValue() function in Qlik returns the first (or second) value from one field, sorted on another field. For example, the first Employee ID by Contact Date. Friday Qlik Test Prep Functions Qlik Script
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