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)

QlikView charts

In this section, we will look at QlikView charts. We will cover bar charts, and then we will look at how we can switch between chart types. The bar chart is the chart that is used most frequently in pretty much every dashboard that you will see, and you will learn how you can create it in QlikView:

  1. To do this, let's move on to QlikView. We can right-click on the dashboard, go to New Sheet Object, and click on the Chart option. This will give you the following window:

You can see the various types of charts available there.

  1. We will select Bar Chart, and click on Next.
  2. Then, we will choose the dimension that we want to display in our chart, which we will take as DISTANCE_GROUP, since it shows us how much distance an airline is covering. So, let's go ahead and add that, and then click on Next.
  3. After that, you need to enter an expression. Let's use...