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)

Input boxes

Here, we will look at how to create an input box, why we use it, the variables in it, and creating interactivity between input boxes and charts. An input box basically adds interactivity in your dashboard. It allows the end user to give an input on the dashboard in your charts or matrix – wherever you have done the configuration, the chart or matrix will be updated accordingly.

To see this in action, let's use our QlikView application and create an input box. To do that, we need to right-click on the dashboard, go to New Sheet Object, and select the Input Box option. In the window, we need to assign a variable to the box; in our case, let's assign a variable called Target.

Now, let's say we want a target of 120 million, but when you input the value and press Enter, nothing happens. To do that, we need to do some configuration. We need to add Target...