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

Why server jobs fail

There are many reasons why jobs fail on a server; here are a few of the common ones and ideas on how to avoid them. Also, ensure that your document has the Generate Log File option selected in the General tab of Document Properties as this makes identifying the issue a lot easier. The default log file created by QlikView Server is rarely of any help, but the document log file gives us more helpful error messages at approximately the script line that failed.

Connection failures

If you are connected to a database using OLE DB, you have the option of supplying a username and password for database access. One common failure here is that the password may have expired. It is better to set up your connection to use the NT authentication and have the account running the QlikView Distribution service added to the database list of authenticated users. (Only read access is required most of the time.)

Excel spreadsheets

There are many reasons why these fail, but most of them are due...