QlikView unlocked: unlock more than 50 amazing tips and tricks to enhance your QlikView skills

Cover; Copyright; Credits; About the Authors; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 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; Chapter 2: Building the Correct Environment; Creating and enforcing site standards; Background; How to do it.

Designing a site-style templateBackground; 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; Chapter 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 selectionsNever 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; Chapter 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 itExciting 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; Chapter 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 modelBackground; 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; Chapter 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.