In this chapter, we will focus on some interesting and useful functions available in Qlik Sense:
- Using an extended interval match to handle slowly changing dimensions
- Using the
Previous()
function to identify the latest record for a dimensional value - Using the
NetworkDays()
function to calculate the working days in a calendar month - Using the
Concat()
function to display a string of field values as a dimension - Using the
MinString()
function to calculate the age of the oldest case in a queue - Using the
RangeSum()
function to plot cumulative figures in trendline charts - Using the
Fractile()
function to generate quartiles - Using the
FirstSortedValue()
function to identify the median in a quartile range - Using the
Declare
andDerive
functions to generateCalendar
fields - Setting up a moving annual total figure
- Using the
For Each
loop to extract files from a folder - Using the
Peek()
function to create a currency exchange rate calendar - Using the
Peek()
function to create a trial balance...