QlikView Unlocked电子书

QlikView Unlocked

Table of Contents

QlikView Unlocked

Credits

About the Authors

About the Reviewers

www.PacktPub.com

Support files, eBooks, discount offers, and more

Why subscribe?

Free access for Packt account holders

Instant updates on new Packt books

Preface

The QlikView Unlocked project

QlikView is huge

Qlik Community

LinkedIn

QlikView blogs

Books about QlikView

Service releases

Qlik events

Local groups

What this book covers

What you need for this book

Who this book is for

Conventions

Reader feedback

Customer support

Downloading the color images of this book

Errata

Piracy

Questions

1. Behind Every Successful Project Is a Plan

Why infrastructure is important

Background

How to do it

Environments and architecture

Background

How to do it

Building a reusable, maintainable environment

Background

How to do it

QlikView projects need discipline too!

Background

How to do it

Can you deliver?

Background

How to do it

Summary

2. Building the Correct Environment

Creating and enforcing site standards

Background

How to do it

Designing a site-style template

Background

How to do it

Making document names meaningful

Background

How to do it

Separation of responsibilities, change management, and thinking about security

Background

How to do it

Understanding the differences in environments

Background

How to do it

With or without Publisher?

Summary

3. Are You Sitting Comfortably? Be More Productive

A bit more about license types

Background

How to do it

Make yourself comfortable and productive

Background

How to do it

Most recently used files

Selection appearance

Search settings

Max values in current selections

Never lose your work

Background

How to do it

Some useful global settings

Background

How to do it

Default Styling Mode

Always Use Logfiles for New Documents

Always Show Design Menu Items

Some best practices for developers

Background

How to do it

Hidden features – Easter eggs

Background

How to do it

A few do's and don'ts

Background

How to do it

Summary

4. It's All About Understanding the Data

Understanding the data you're working with

Background

How to do it

Even a few list and table boxes tell you and the user a lot

Background

How to do it

Exciting users with a prototype, then throwing it away

Background

How to do it

Dirty data and what to do about it

Background

How to do it

Incorrect or erroneous data

Inconsistent data

Duplication

Is this the right place for this data?

Background

How to do it

Building a structure of QVD layers

Background

How to do it

Incremental loads and performance

Background

How to do it

Performance

Summary

5. The Right Data Model Pays Dividends

Synthetic keys and why they're sometimes bad news

Background

How to do it

Link tables

Background

How to do it

Avoiding loops in the data model

Background

How to do it

Simplify, simplify, simplify – never have subtables that you don't need

Background

How to do it

Data islands, single calendars, and set analysis

Background

How to do it

Avoiding problems with JOIN

Background

How to do it

Summary

6. Make It Easy on Yourself – Some QlikView Tips and Tricks

A few coding tips

Keep the coding style constant

Use MUST_INCLUDE rather than INCLUDE

Put version numbers in your code

Do stringing in the script, not in screen objects

Surprising data sources

Include files

Change logs

Calculations and flags in the script

Previous() and Peek() functions

Preceding load on preceding load

Finding min and max

Autonumber

Reading from a spreadsheet

Summary

7. Improving Chart Performance and Usability

Don't forget screen performance

Cached expressions

Multiple selection criteria

Copying expressions

Reusing chart expressions

Hidden graphics

Making charts more readable

Helping the user – Help Text

Resizing objects

Stopping objects from being moved

Defaulting the scroll bar to the right of a chart

Summary

8. To Deployment and Beyond

Security and Section Access

Explanation

Background

How to do it

Physical Network Access

Document CALs

With Publisher

Section Access

Hiding fields

Passing additional parameters

Section Access with Data Reduction and QlikView Publisher

Why server jobs fail

Connection failures

Excel spreadsheets

Drive letters

QlikView engines

Antivirus software

QVD

Deploying from development to UAT and on to production

Explanation

Background

How to do it

The golden source

Explanation

Background

How to do it

Why Publisher isn't always a good thing

Explanation

Background

How to do it

Your two best friends

Explanation

Background

How to do it

It will never be perfect but it will be close

Explanation

Background

How to do it

Summary

A. Hidden Image List

Index