Skip to main content

Tutorial - Next steps in scripting

Welcome to this tutorial, which will introduce you to advanced scripting in Qlik Sense.

Once you are familiar with the basics of scripting, you can start to perform more sophisticated operations on your data as you load it into Qlik Sense. This can include, for example, transforming data using cross-tables, cleansing data, and creating and loading data from Qlik data files known as QVD files.

What you will learn

After completing this tutorial, you should be comfortable with loading data using some of the more advanced scripting functions in Qlik Sense.

Who should take this course

You should be familiar with the basics of scripting in Qlik Sense. That is, you have loaded data and manipulated data using scripts.

If you have not already done so, we recommend completing the Scripting for beginners tutorial.

You require access to the data load editor and should be allowed to load data in SaaS editions of Qlik Sense.

What you need to do before you start

Download this package and unzip it on your desktop:

Next steps in scripting tutorial

The package contains the following data files that you need to complete the tutorial.

  • Cutlery.xlsx
  • Data.xlsx
  • Employees.xlsx
  • Events.txt
  • Intervals.txt
  • Product.xlsx
  • Salesman.xlsx
  • Transactions.csv
  • Winedistricts.txt

The package also contains a copy of the Advanced Scripting Tutorial app. Additional script sections in the app contain the scripts for the other apps that you create in this tutorial. You can upload the app to your hub in Qlik Sense Enterprise SaaS.

We recommend building the app yourself as described in the tutorial to maximize your learning. Additionally, you would have to upload and connect to your data files as described in the tutorial for the data loads to work.

However, if you run into problems, the app may help you troubleshoot. We have indicated which script segments are associated with each lesson.

Lessons in this tutorial

Depending on your experience with Qlik Sense, this tutorial should take 3-4 hours to complete. The topics are designed to be completed in sequence. However, you can step away and return at any time. There are, mercifully, no tests.

Further reading and resources

Your opinion matters

We appreciate any feedback that you may have. Please use the section below to let us know how we're doing.