Book Image

QlikView Unlocked

By : Andrew Dove, Roger Stone
Book Image

QlikView Unlocked

By: Andrew Dove, Roger Stone

Overview of this book

QlikView Unlocked will provide you with new insights to get the very best from QlikView. This book will help you to develop skills to work with data efficiently. We will cover all the secrets of unleashing the full power of QlikView, which will enable you to make better use of the tool and create better results for future projects. In the course of this book, we will walk you through techniques and best practices that will enable you to be more productive. You will gain quick insights into the tool with the help of short steps called ”keys,” which will help you discover new features of QlikView. Moving on you will learn new techniques for data visualization, scripting, data modeling, and more. This book will then cover best practices to help you establish an efficient system with improved performance. We will also teach you some tricks that will help you speed up development processes, monitor data with dashboards, and so on. By the end of this book, you will have gained beneficial tips, tricks, and techniques to enhance the overall experience of working with QlikView.
Table of Contents (16 chapters)
QlikView Unlocked
About the Authors
About the Reviewers
Hidden Image List

A few do's and don'ts

There are some things you should always do, and some you just shouldn't! You will find many little things in QlikView that you need to lock away in your memory, and they'll all add to your overall skill level.


Some do's and don'ts may be thought of as best practice or useful site standards, but here are a few that work better on a personal level.

How to do it


  • Use F1: QlikView's syntax is different from other languages. Use the F1 key to bring up context-sensitive help, showing you the full syntax and parameter list. This helps you learn the syntax and helps ensure that you get the correct results from the start.

  • Drop Table: Drop Table in the script is a good way of making things more efficient. Remember, though, that dropping one table with identical fields to another will drop both!

  • Drop Fields: If you drop fields, use a list rather than individual statements; it is much more efficient.

  • Use the fora: Sometimes, QlikView throws up something odd that does not...