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 Qlik Cloud.
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 the Analytics activity center in Qlik Cloud.
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
- Qlik offers a wide variety of resources when you want to learn more.
- Qlik online help is available.
- Training, including free online courses, is available in the Qlik Continuous Classroom.
- Discussion forums, blogs, and more can be found in Qlik Community.
Your opinion matters
We appreciate any feedback that you may have. Please use the section below to let us know how we're doing.