You are previewing QlikView Unlocked.
O'Reilly logo
QlikView Unlocked

Book Description

Unlock more than 50 amazing tips and tricks to enhance your QlikView skills

About This Book

  • Learn QlikView development best practices from the experts

  • Discover valuable tips, tricks, and undocumented features

  • A fast-paced guide with techniques and best practices to optimize high-performance, robust, and scalable applications

  • Who This Book Is For

    QlikView Unlocked is intended for anyone with at least some experience in designing, developing, or supporting QlikView applications. Whether you are new to QlikView or are a seasoned developer, there is something for everyone in this book.

    What You Will Learn

  • Build the QlikView environment correctly so that it is flexible and robust

  • Deliver a successful QlikView project

  • Understand and implement QlikView best practices

  • Discover the best way to prototype, develop, and deploy applications

  • Overcome data modeling challenges

  • Explore the in’s and out’s of Section Access

  • Solve post-deployment issues in Server and Publisher

  • In Detail

    QlikView is considered as one of the most used tool for Business Intelligence (BI). An efficient BI tool should provide five important capabilities for effective data analysis—collection (gathering important information), reporting, analysis (the ability to interact with data), visualization (the presentation of data), and discovery (exploring data). QlikView offers all these necessary skills required to deal with big data in real-world scenarios.

    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.

    Style and approach

    Written in a fairly informal style, this is a book that can be read cover-to-cover or simply used as a ”how-to” reference. Using real-world examples with clear explanations, code samples, and screenshots, you will be able understand each topic fully. You will be able to apply the knowledge gained to your QlikView projects.

    Downloading the example code for this book. You can download the example code files for all Packt books you have purchased from your account at http://www.PacktPub.com. If you purchased this book elsewhere, you can visit http://www.PacktPub.com/support and register to have the code file.

    Table of Contents

    1. QlikView Unlocked
      1. Table of Contents
      2. QlikView Unlocked
      3. Credits
      4. About the Authors
      5. About the Reviewers
      6. www.PacktPub.com
        1. Support files, eBooks, discount offers, and more
          1. Why subscribe?
          2. Free access for Packt account holders
          3. Instant updates on new Packt books
      7. Preface
        1. The QlikView Unlocked project
        2. QlikView is huge
        3. Qlik Community
        4. LinkedIn
        5. QlikView blogs
        6. Books about QlikView
        7. Service releases
        8. Qlik events
        9. Local groups
        10. What this book covers
        11. What you need for this book
        12. Who this book is for
        13. Conventions
        14. Reader feedback
        15. Customer support
          1. Downloading the color images of this book
          2. Errata
          3. Piracy
          4. Questions
      8. 1. Behind Every Successful Project Is a Plan
        1. Why infrastructure is important
          1. Background
          2. How to do it
        2. Environments and architecture
          1. Background
          2. How to do it
        3. Building a reusable, maintainable environment
          1. Background
          2. How to do it
        4. QlikView projects need discipline too!
          1. Background
          2. How to do it
        5. Can you deliver?
          1. Background
          2. How to do it
        6. Summary
      9. 2. Building the Correct Environment
        1. Creating and enforcing site standards
          1. Background
          2. How to do it
        2. Designing a site-style template
          1. Background
          2. How to do it
        3. Making document names meaningful
          1. Background
          2. How to do it
        4. Separation of responsibilities, change management, and thinking about security
          1. Background
          2. How to do it
        5. Understanding the differences in environments
          1. Background
          2. How to do it
            1. With or without Publisher?
        6. Summary
      10. 3. Are You Sitting Comfortably? Be More Productive
        1. A bit more about license types
          1. Background
          2. How to do it
        2. Make yourself comfortable and productive
          1. Background
          2. How to do it
            1. Most recently used files
            2. Selection appearance
            3. Search settings
            4. Max values in current selections
        3. Never lose your work
          1. Background
          2. How to do it
        4. Some useful global settings
          1. Background
          2. How to do it
            1. Default Styling Mode
            2. Always Use Logfiles for New Documents
            3. Always Show Design Menu Items
        5. Some best practices for developers
          1. Background
          2. How to do it
        6. Hidden features – Easter eggs
          1. Background
          2. How to do it
        7. A few do's and don'ts
          1. Background
          2. How to do it
        8. Summary
      11. 4. It's All About Understanding the Data
        1. Understanding the data you're working with
          1. Background
          2. How to do it
        2. Even a few list and table boxes tell you and the user a lot
          1. Background
          2. How to do it
        3. Exciting users with a prototype, then throwing it away
          1. Background
          2. How to do it
        4. Dirty data and what to do about it
          1. Background
          2. How to do it
            1. Incorrect or erroneous data
            2. Inconsistent data
            3. Duplication
        5. Is this the right place for this data?
          1. Background
          2. How to do it
        6. Building a structure of QVD layers
          1. Background
          2. How to do it
        7. Incremental loads and performance
          1. Background
          2. How to do it
            1. Performance
        8. Summary
      12. 5. The Right Data Model Pays Dividends
        1. Synthetic keys and why they're sometimes bad news
          1. Background
          2. How to do it
        2. Link tables
          1. Background
          2. How to do it
        3. Avoiding loops in the data model
          1. Background
          2. How to do it
        4. Simplify, simplify, simplify – never have subtables that you don't need
          1. Background
          2. How to do it
        5. Data islands, single calendars, and set analysis
          1. Background
          2. How to do it
        6. Avoiding problems with JOIN
          1. Background
          2. How to do it
        7. Summary
      13. 6. Make It Easy on Yourself – Some QlikView Tips and Tricks
        1. A few coding tips
          1. Keep the coding style constant
          2. Use MUST_INCLUDE rather than INCLUDE
          3. Put version numbers in your code
          4. Do stringing in the script, not in screen objects
        2. Surprising data sources
        3. Include files
        4. Change logs
        5. Calculations and flags in the script
        6. Previous() and Peek() functions
        7. Preceding load on preceding load
        8. Finding min and max
        9. Autonumber
        10. Reading from a spreadsheet
        11. Summary
      14. 7. Improving Chart Performance and Usability
        1. Don't forget screen performance
        2. Cached expressions
        3. Multiple selection criteria
        4. Copying expressions
        5. Reusing chart expressions
        6. Hidden graphics
        7. Making charts more readable
          1. Helping the user – Help Text
        8. Resizing objects
        9. Stopping objects from being moved
        10. Defaulting the scroll bar to the right of a chart
        11. Summary
      15. 8. To Deployment and Beyond
        1. Security and Section Access
          1. Explanation
          2. Background
          3. How to do it
            1. Physical Network Access
            2. Document CALs
            3. With Publisher
            4. Section Access
            5. Hiding fields
            6. Passing additional parameters
            7. Section Access with Data Reduction and QlikView Publisher
        2. Why server jobs fail
          1. Connection failures
          2. Excel spreadsheets
          3. Drive letters
          4. QlikView engines
          5. Antivirus software
          6. QVD
        3. Deploying from development to UAT and on to production
          1. Explanation
          2. Background
          3. How to do it
        4. The golden source
          1. Explanation
          2. Background
          3. How to do it
        5. Why Publisher isn't always a good thing
          1. Explanation
          2. Background
          3. How to do it
        6. Your two best friends
          1. Explanation
          2. Background
          3. How to do it
        7. It will never be perfect but it will be close
          1. Explanation
          2. Background
          3. How to do it
        8. Summary
      16. A. Hidden Image List
      17. Index