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)

Creating a QVD file

In this section, we will be looking at storing data in a QVD file. It is helpful as a QlikView developer to store data in a QVD file, because it helps in optimizing the data, and compresses the data into a much smaller size as compared to the original size. One major benefit of a QVD file is when you need to share the data with other QlikView developers who are working on a similar application, and need data that you have already prepared, you can send them a QVD file, which they can easily upload into their QlikView document.

So, let's go to QlikView and open the application that we are working on. We will go to the Edit Screen window by using the Ctrl + E shortcut. We can see the script that we use to import the data from the Excel file. So, the plan here is to collect the data from the Excel file and store it as a QVD file.

Now, to store the data in...