Chapter 5. Useful Functions

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 Derive and Declare functions to generate Calendar 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 sheet

Introduction

In 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.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset