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

Enhancing the classics: tips and tricks


In the following section, you will find a bunch of recipes that are valuable by themselves, but moreover, they contain interesting features that you can apply in many other contexts. If you want to follow the exercises (which I highly recommend), download the materials for this chapter from https://qlikfreak.wordpress.com/books/.

Twin bar chart

This graph is built with two sets of bars going in opposite directions. It can be applied in any situation where you need to compare two groups face to face. For instance, brick and mortar against online sales (x-axis) divided by the average ticket size (y-axis).

Example: Population Pyramid

Relevant features: Chart orientation, stacked bars, and cluster distance

To create this twin bar chart, perform the following steps:

  1. Create a new bar chart using Age as the dimension.

  2. Our first expression will represent the female population (on the right-hand side):

    sum({$<Gender={'Female'}>} Population) 
  3. Now, add a second...