In this chapter, we will focus on some interesting and useful functions available in Qlik Sense:
Previous()
function to identify the latest record for a dimensional valueNetworkDays()
function to calculate the working days in a calendar monthConcat()
function to display a string of field values as a dimensionMinString()
function to calculate the age of the oldest case in a queueRangeSum()
function to plot cumulative figures in trendline chartsFractile()
function to generate quartilesFirstSortedValue()
function to identify the median in a quartile rangeDerive
and Declare
functions to generate Calendar
fieldsFor Each
loop to extract files from a folderPeek()
function to create a currency Exchange Rate CalendarPeek()
function to create a Trial Balance sheetIn this chapter, we will shift our focus to the functions available in Qlik Sense. In certain situations, the functions can be used in the script or they can be used in frontend expressions to get solutions for complex requirements. All the functions discussed in this chapter will find their way into most of the Qlik Sense implementations.