Book Image

Qlikview Unlocked

Book Image

Qlikview Unlocked

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.

Related Content you might be interested in

Current Title:

Small book image
Qlikview Unlocked
Nov, 2015 | 196 pages
No titles found
Table of Contents (16 chapters)
QlikView Unlocked
QlikView Unlocked
Credits
Credits
About the Authors
About the Authors
About the Reviewers
About the Reviewers
www.PacktPub.com
www.PacktPub.com
Preface
Preface
Free Chapter
1
Behind Every Successful Project Is a Plan
Behind Every Successful Project Is a Plan
Why infrastructure is important
Environments and architecture
Building a reusable, maintainable environment
QlikView projects need discipline too!
Can you deliver?
Summary
2
Building the Correct Environment
Building the Correct Environment
Creating and enforcing site standards
Designing a site-style template
Making document names meaningful
Separation of responsibilities, change management, and thinking about security
Understanding the differences in environments
Summary
3
Are You Sitting Comfortably? Be More Productive
Are You Sitting Comfortably? Be More Productive
A bit more about license types
Make yourself comfortable and productive
Never lose your work
Some useful global settings
Some best practices for developers
Hidden features – Easter eggs
A few do's and don'ts
Summary
4
It's All About Understanding the Data
It's All About Understanding the Data
Understanding the data you're working with
Even a few list and table boxes tell you and the user a lot
Exciting users with a prototype, then throwing it away
Dirty data and what to do about it
Is this the right place for this data?
Building a structure of QVD layers
Incremental loads and performance
Summary
5
The Right Data Model Pays Dividends
The Right Data Model Pays Dividends
Synthetic keys and why they're sometimes bad news
Link tables
Avoiding loops in the data model
Simplify, simplify, simplify – never have subtables that you don't need
Data islands, single calendars, and set analysis
Avoiding problems with JOIN
Summary
6
Make It Easy on Yourself – Some QlikView Tips and Tricks
Make It Easy on Yourself – Some QlikView Tips and Tricks
A few coding tips
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
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
Resizing objects
Stopping objects from being moved
Defaulting the scroll bar to the right of a chart
Summary
8
To Deployment and Beyond
To Deployment and Beyond
Security and Section Access
Why server jobs fail
Deploying from development to UAT and on to production
The golden source
Why Publisher isn't always a good thing
Your two best friends
It will never be perfect but it will be close
Summary
Hidden Image List
Hidden Image List
Index
Index

About the Authors

Roger Stone is a freelance QlikView consultant based in Oxfordshire, UK. He entered the computer industry in 1977 and has worked with a huge variety of programming languages and tools all over the world. Finally discovering QlikView in late 2009, he has worked on numerous successful QlikView implementations in a wide range of industries, from insurance to healthcare.

In 2010, Roger founded One QV Ltd with coauthor Andrew Dove, and together they developed 1HR, a QlikView-based human resources application aimed at the National Health Service in the UK. 1HR has since been deployed to more than 25 NHS Trusts.

He currently holds QlikView Designer, Developer, and Systems Administrator Certifications for QlikView 11. Roger enjoys travel, Belgian beer, and military history, all of which are combined in his frequent trips to Belgium.

Andrew Dove is a freelance QlikView consultant based in Darlington, UK. He has more than 35 years of experience in various IT development roles and developed a highly successful payroll system in the 1980s and 90s.

Andrew began his QlikView journey in 2010 and joined coauthor Roger Stone to found One QV Ltd. He has since worked on several large QlikView projects in healthcare, manufacturing, pharmaceuticals, and financial services.

Andrew holds QlikView Designer, Developer, and Systems Administrator Certifications for QlikView 11. He enjoys travel, French wine, and cheese, all of which feature in his frequent trips to France.

Previous Section
Next Chapter