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

Variables – making your life easier


Variables are one of the most flexible elements in the QlikView realm. As we have seen throughout the book, you can use them as part of your script, the navigation schema or as a mechanism for the user to interact with the app. Likewise, they can help you standardize your dashboards by creating consistent color palettes or speed up your development by making it easier to create new calculations.

Formulas and Set Analysis

Stunning dashboards are not only functional, user friendly, and eye catching, but also robust and easy to maintain. One of the benefits of using variables in a QlikView app is that you can encapsulate common calculations. For example, imagine that you are dealing with an expression such as this one:

=sum({$<Category={'A', 'B', 'C'}, Cancelled={0}>} Sales)

Instead of copying and pasting it onto several charts time and again, you can create a variable called vSales to store it. Now, whenever you need to use it, you just have to type the...