Summary

In this book, we have learned when to use QlikView along with many of the multiple features of QlikView. We have loaded data from Excel and learned about other data sources. We have experimented with performing analysis with QlikView in the section where we found the out of balance amount. We have modified the Load Script, loaded additional spreadsheets, and linked data.

We examined key performance indicators and learned about the different options available with QlikView to display them. We created the three most common financial KPIs and, during the process, learned about set expressions. We have created or modified most of the sheet objects available in QlikView in the preceding chapters, and created a common size income statement for analysis.

We have learned that dashboards should display key information in a quick-to-digest format, and that gauges, dials, and thermometers are often used incorrectly, causing confusion rather than clarification. We examined both the display choices...