Reader small image

You're reading from  Creating Stunning Dashboards with QlikView

Product typeBook
Published inOct 2015
Publisher
ISBN-139781782175735
Edition1st Edition
Right arrow
Author (1)
Julian Villafuerte
Julian Villafuerte
author image
Julian Villafuerte

Julian Villafuerte is a founding member of Evolution Consulting, a Mexican firm which provides QlikView consulting services throughout the Americas. Since 2010, he has helped several companies to define effective strategies for data management and business analysis. As a consultant, he has worked in application development, project management, pre-sales and training for many industries, including retail, manufacturing and insurance. In October, 2015, he published “Creating Stunning Dashboards with QlikView”, a practical handbook focused on developing useful and engaging analytical applications. He has a Master's degree in Information Technology Management and teaches at the Tecnológico de Monterrey in Mexico City. Recently, he started a blog called QlikFreak (https://qlikfreak.wordpress.com/), where he shares tips and tricks about data visualization, scripting and best practices.
Read more about Julian Villafuerte

Right arrow

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,...

lock icon
The rest of the page is locked
Previous PageNext Page
You have been reading a chapter from
Creating Stunning Dashboards with QlikView
Published in: Oct 2015Publisher: ISBN-13: 9781782175735

Author (1)

author image
Julian Villafuerte

Julian Villafuerte is a founding member of Evolution Consulting, a Mexican firm which provides QlikView consulting services throughout the Americas. Since 2010, he has helped several companies to define effective strategies for data management and business analysis. As a consultant, he has worked in application development, project management, pre-sales and training for many industries, including retail, manufacturing and insurance. In October, 2015, he published “Creating Stunning Dashboards with QlikView”, a practical handbook focused on developing useful and engaging analytical applications. He has a Master's degree in Information Technology Management and teaches at the Tecnológico de Monterrey in Mexico City. Recently, he started a blog called QlikFreak (https://qlikfreak.wordpress.com/), where he shares tips and tricks about data visualization, scripting and best practices.
Read more about Julian Villafuerte