Using the Previous() function to identify the latest record read for a dimensional value

In a line-level table, there are multiple records stored for a single dimensional value. For example, an Order Line table will have multiple lines for the same OrderID. Business requirements may warrant us to only consider the first or the latest line for each order. This can be done using the Previous() function available in Qlik Sense.

Getting ready

For the sake of continuity, we will make use of the same script and application as in the previous recipe. We will determine the most recent position of any employee during their tenure within the organization.

 

 

How to do it…

1. Open the Data load editor. Change the name of the EmployeeInt table in the script to EmployeeIntTemp.
2. Insert the following lines of code after the EmployeeIntTemp table LOAD command. If you are copying and pasting the code in the Data load editor, make sure that the single quotes are copied in a proper format:

EmployeeInt: 
LOAD *, 
if...