As we described in previous chapters, Qlik Sense makes it easy to manipulate and load data from different sources through a visual interface called Data Manager. Nevertheless, Qlik Sense comes with a very powerful scripting language that is shared with its father, QlikView, mostly in its totality and making these tools unique in the market.
Qlik Sense inherited most of the script elements from QlikView. Most of the functions found in QlikView can still be used in Qlik Sense. Other new functions, such as declare and derive, were introduced with Qlik Sense and are not available in QlikView. These two functions are described in Chapter 7, Best Practices for Loading Data in Qlik Sense, so I recommend you refer to them after reading this chapter if you have not done so already.
There are tons of functions in Qlik Sense, however, my intention is to describe the functions that, from my experience, are frequently used.
In this chapter, we will learn about:
- Formatting settings through variables
- Script control statements
- Table statistics
- Data security with Section Access
- Advanced sample script
Everything that is showed in this chapter will be done within a script. As a reminder, to open the script editor, you have to:
- Create a new application using Qlik Sense Desktop, Enterprise, or Cloud
- Click on the Navigation button
- Click on Data load editor
The following image shows steps 2 and 3:
