Databases Reference
In-Depth Information
Scripting
In the previous chapter, we looked at building the frontend objects for use in
dashboards, analyses, and reports. While it may be tempting to keep working on
the frontend, we still have a bit of work to do on the backend. Very often input data
is not in the exact same format as is required in the target data model, so in this
chapter we will look at how we can use QlikView's built-in scripting language to
transform our data.
We will first look at the script editor and some of the most important script
statements, and see how we can use them to manipulate tables and control the flow
of the script. This is followed by a look at some of the most commonly used functions
for dealing with conditions and various data types. As QlikView scripts can get quite
big and complex we will look at some ways in which we can debug our scripts. Next,
we look at how we can properly organize and standardize our scripts so that they
are easy to understand and maintain. We conclude this chapter by looking at how we
can re-use parts of our script within and between our QlikView documents.
In this chapter, specifically, we will learn about:
• The Script Editor
• The most important script statements and how to use them to manipulate
tables and control the flow of the script
• Operators and functions for dealing with various data types
• The options for debugging your script
• How to organize and standardize your script
• How to re-use your script
