This chapter has given us a lot of good information on functions that we can use when writing scripts.

After reviewing the basics on loading data, we then went into how to count records and the useful functions that we have for that purpose. We had a discussion on the best way to optimize data loading. We then explored variables and the Dollar-sign Expansion in the script. We talked about fundamental control structures and had a good look at Table Files Wizard, followed by a discussion on using different functions to grab data from different directions.

Finally, we had a very brief discussion on reusing code and the use of libraries such as Rob Wunderlich's QlikView components.

In the next and final chapter, we will have a look at the area of data visualization.