Hands-On Dashboard Development with QlikView电子书

Title Page

Copyright and Credits

Hands-On Dashboard Development with QlikView

About Packt

Why subscribe?

Packt.com

Contributor

About the author

Packt is searching for authors like you

Preface

Who this book is for

What this book covers

To get the most out of this book

Download the example code files

Download the color images

Conventions used

Get in touch

Reviews

Getting Started with QlikView

Prerequisites

Installing QlikView

Exploring QlikView

Creating a document

Saving the document

Important terminologies in QlikView

QlikView selections

QlikView architecture

Exploring data in QlikView

Summary

Getting Data in QlikView and Creating Your First App

Setting up the structure

Creating an app

Importing data from Excel

Reviewing the data

Understanding facts and dimensions

Dimensions and measures

Best practices for dimensions and facts

Understanding list boxes

Selections in list boxes

Creating new tabs

Adding filters to the app

Summary

Creating Data Models

Creating a star schema

Implementing the star schema

Getting data from databases

Getting data from QVD files

Analyzing the resulting model

Information density

Subset ratio

Tags

Creating a QVD file

Summary

Components in QlikView

List boxes

Layout of columns

Ordering of data

Showing frequency of values

QlikView charts

Changing the chart type

Multi boxes

Properties of multi box

Bookmarks

Properties of bookmarks

Input boxes

Text objects

Summary

Building a Dashboard

Adding KPIs

Adding charts

Block chart

Scatter chart

Pivot table chart

Adding dynamic chart displays

Auto-minimize

Different types of expressions

Group expressions

Drill-down expressions

Containers

Buttons

Summary

Set Analysis

The basics of set analysis

What set analysis means

Set analysis syntax structure

Assignment operators

Assignment operators in action

Set operators

Set operators in action

Element functions

Element functions in action

Summary

Adding Security

Security scripts

Best practices for enabling a security script

Understanding various types of securities

Configuring security

Advanced security

Troubleshooting issues in QlikView

Summary

Other Books You May Enjoy

Leave a review - let other readers know what you think