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)

Advanced security

In this section, we will look at adding security at the data level. In the previous section, we added security at a user level, based on the username and password. In this section, we will implement it at the data level so that when a particular user is entering our application, the data will be reduced or hidden for that particular user. We will use the following steps to do so:

  1. We will open the application that we worked on in the previous section, and go to the Edit Script window. Here, we will open up our hidden script using the credentials that we used when we created the script.
  1. Now, we will add some changes in the script. We need to add the fields where you want to reduce the data. First of all, let's look at the data model to see which fields we want to reduce, so use the Ctrl + T shortcut to bring up the data model, as shown in the following...