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

Is that a table?


Not all tables are meant to display numbers. Actually, with a little creativity and some advanced customization, you can create amazing visualizations that will enhance your applications and give a fresh look to your dashboards.

The waffle chart

For a strange reason, it looks like most area-based graphics have something to do with food. However, this time, we are not talking about pies or doughnuts, but waffle charts. These visualizations are based on a pivot table and rely on cell customization to display a percentage.

Example: Waffle chart.

Relevant features: ValueLoop(), RowNo(), and ColumnNo().

Unlike most visualizations, the construction of the waffle chart is a little unorthodox because it is based on two synthetic dimensions (that is, they don't exist in the data model) and a dummy expression. Our objective is to create a matrix with 100 cells that will be displayed in different colors depending on a metric. In order to create a waffle chart, do the following:

  1. First,...