Book Image

Creating Stunning Dashboards with QlikView

By : Julian Villafuerte
Book Image

Creating Stunning Dashboards with QlikView

By: Julian Villafuerte

Overview of this book

QlikView is one of the most powerful analytical tools in the market. Based on an in-memory associative model, it lets users freely navigate through the data, spot trends and make better decisions. This platform is capable of integrating a wide range of data sources like ERP systems, data warehouses or spreadsheets into a single application in order display dashboards with state-of-the-art visualizations. Creating Stunning Dashboards with QlikView is an easy to follow handbook that guides you through the process of creating an effective and engaging dashboard that delivers tangible value to the business. It starts with the identification of the business needs and the definition of the main KPIs, and takes you all the way to the application rollout. Throughout the book, you will learn how to apply some of the best practices in the field of data visualization, create a robust navigation schema, chose the best chart types for each scenario and many other things that will help you create effective dashboards that uncover all the stories behind the data.
Table of Contents (16 chapters)
Creating Stunning Dashboards with QlikView
Credits
Foreword
About the Author
About the Reviewers
www.PacktPub.com
Preface
4
It's Not Only about Charts
Index

Subroutines


Subroutines are small chunks of code that you can easily include in your apps to automate common actions. As they are built using QlikView script, they can perform a wide variety of actions, and their ability to receive parameters makes them very flexible.

In this chapter's material, you can find an example that includes three bonus subroutines:

  • StoreQVD: This subroutine stores a table in QVD. Afterwards, it drops the table and keeps some useful metadata, such as the number of records and the time spent loading each element.

  • ImageBundleLoad: Instead of creating an inline table with all the images you need in your dashboard, arrange them in a single folder (it can contain several subfolders), and load them automagically with this subroutine (no, that's not a typo).

  • LoadVariables: Using the Variable Overview window to create all the variables in the document can be troublesome and sometimes give you nasty surprises (if you are a seasoned QlikView developer, you have surely erased...