Book Image

Hands-On Dashboard Development with QlikView

By : Abhishek Agarwal
Book Image

Hands-On Dashboard Development with QlikView

By: Abhishek Agarwal

Overview of this book

QlikView is one of the market leaders when it comes to building effective Business Intelligence solutions. This book will show how you can leverage its power to build your own dashboards to tell your own data story. The book starts with showing you how to connect your data to QlikView and create your own QlikView application. You will learn how to add data from multiple sources, create a data model by joining data, and then review it on the front end. You will work with QlikView components such as charts, list boxes, input boxes, and text objects to create stunning visualizations that help give actionable business insights. You will also learn how to perform analysis on your data in QlikView and master the various types of security measures to be taken in QlikView. By the end of this book, you will have all the essential knowledge required for insightful data storytelling and creating useful BI dashboards using QlikView.
Table of Contents (9 chapters)

Element functions

We have two different types of element functions, which are as follows:

  • P(): This uses all the possible values of a field.
  • E(): This uses all the excluded values of a field.

The P() function uses all possible values in the field, and the E() function basically excludes, which means that it uses all the excluded fields based on the selection.

Element functions in action

We will now open the QlikView dashboard, go into the properties, and remove the entire expression we added in the previous section. We will replace that with the following expression:

{<Origin_WAC=p(Origin_WAC)>}

Now, whatever I select in the textual filters for Origin_WAC will appear in the dashboard. For example, let's select...