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

Book Description

Want to solve your Business Intelligence headaches? Learn how QlikView can help, and discover a powerful yet accessible BI solution that lets you harness your data

About This Book

  • Design interactive dashboards using QlikView to share sharp BI insights

  • Discover how to create effective data models to manage and harness your data with QlikView’s ETL functionality

  • Learn and implement best practices to successfully integrate QlikView within your organization

  • Who This Book Is For

    If you recognize the challenges of harnessing data for a modern business this book is for. Maybe you already know a little about QlikView – if you want to learn more, QlikView Essentials is a great way to develop your knowledge and skills.

    What You Will Learn

  • Learn the complete QlikView workflow – from loading data, to visualization and analytics

  • Learn how to Load data from different sources, including QVD files and how to optimize data models for accuracy and precision

  • Discover solutions to common data modeling problems, so you can respond quickly to changing situations

  • Create accessible dashboards and quality data visualizations to share insights effectively

  • Learn how to deploy your BI application for optimal availability

  • In Detail

    This guide demonstrates just how easy it is to get started with QlikView and create your own BI application. Featuring an introduction to its core features before exploring how to load data and model it, you’ll soon become more confident that you can take full advantage of QlikView’s capabilities. You will also learn how to use QVD files with QlikView – and how they offer a simpler way of handling data.

    After digging deeper into data handling, as you learn how to use mapping tables and create a master calendar, you’ll then find out how to get the most from QlikView’s visualization features – vital if you are to use your data insights effectively. From accessible and user friendly dashboards to strategies and best practices for subjecting data to further analysis, you can be confident that you’ll be prepared to get the most out of your data with QlikView.

    With details on how to finally secure your application and deploy it for a successful integration in your organization, QlikView Essentials underlines exactly why QlikView is becoming more and more popular for businesses that understand the value of data.

    Style and approach

    The book takes a step-by-step approach to QlikView development, and is explained in an easy-to-follow style. Each topic is accompanied by an exercise so you can put your knowledge into practice. This book will be useful for you no matter what your needs and experience levels with the technology.

    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 If you purchased this book elsewhere, you can visit and register to have the code file.

    Table of Contents

    1. QlikView Essentials
      1. Table of Contents
      2. QlikView Essentials
      3. Credits
      4. About the Author
      5. About the Reviewer
        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. What this book covers
        2. What you need for this book
        3. Who this book is for
        4. Conventions
        5. Reader feedback
        6. Customer support
          1. Downloading the example code
          2. Errata
          3. Piracy
          4. Questions
      8. 1. QlikView Fundamentals
        1. QlikView components
        2. QlikView installation
        3. Getting started
        4. The development life cycle of QlikView implementations
          1. About Adventure Works
          2. User requirements
          3. Analyze data model/data sources
            1. Star schema and snow flake schema
        5. QlikView development setup
        6. Summary
      9. 2. Extract, Transform, and Load
        1. Configuring settings
        2. Scripting essentials
        3. Connecting to the database
          1. Loading the OrderHeader Table
          2. Loading the OrderDetail table
          3. Creating fields in the Order table
          4. Loading the Customer table
          5. Loading the Product table
          6. Resolving the synthetic keys
            1. How to resolve synthetic keys
          7. Removing synthetic keys between the Product and Order Detail tables
          8. Loading the ProductSubcategory table
          9. Loading data from text and Excel files
          10. Loading the Product Category table
          11. Loading Employee.xlsx
          12. Circular reference and loosely coupled tables
            1. Circular reference
            2. Loosely coupled tables
            3. Resolving circular reference
          13. Loading the SalesTerritory and Shipment tables
          14. Loading an Inline table
          15. The Qualify statement
          16. Loading the Shippers table
          17. A word about resident load and Exists
          18. Finding the sales person
          19. Using If statements in the script
          20. Including files using the Include statement
          21. More on Table Viewer
          22. Time to review your data model so far
        4. Summary
      10. 3. Optimizing Your Data Model
        1. Mapping table essentials
        2. Mapping load – Territory table
          1. Mapping load – Product Category and ProductSubcategory tables
          2. Mapping load – ProductSubcategory table
          3. Mapping load – CountryRegion_Inline
        3. Concatenation
          1. Concatenation example
            1. Automatic Concatenation
            2. NoConcatenate
            3. Forced concatenation
        4. Joins
          1. Join Orders and Order Detail
          2. Left join SalesPerson
          3. Aggregating data
          4. Concatenating the new Employees table
        5. Reviewing the final data model
        6. Summary
      11. 4. Data Modeling Challenges
        1. Crosstable essentials
        2. Loading EmployeeSalesTarget.xlsx
        3. Link table
          1. Link table essentials
          2. Creating a link table
        4. Variables in QlikView
          1. Using variables to set the file path
        5. Master calendar
        6. The IntervalMatch function
        7. QlikView Data Files (QVD)
          1. Creating QVD files for our data model
        8. Optimized load – reading QVD
          1. Reading QVD files
        9. Best practices of data modeling
        10. Summary
      12. 5. Creating Dashboards
        1. Dashboarding essentials
        2. Getting started
          1. Associative experience
          2. Binary load
            1. Exploring menu items
        3. Sheet objects
        4. Creating a multi-tab application
          1. The dashboard sheet
          2. Creating list boxes for other fields
            1. Options to copy and paste objects
            2. Placing a logo on the dashboard sheet
        5. Creating a bar chart
          1. Expression Overview
        6. Creating a text object
        7. Creating a scatter chart
        8. The story of two tables
          1. Creating a straight table
          2. Enhancing your tables
            1. Groups
            2. Creating a drill-down group
            3. Creating a cyclic group
            4. Creating a pivot table
              1. Container
        9. Dimension limits
          1. Interactivity using text objects
          2. Some more charts
            1. Line charts
            2. Combo charts
            3. Pie charts
        10. Some important functions
          1. The Aggr function
          2. Nested aggregation
          3. Other functions
        11. Summary
      13. 6. Comparative Analysis
        1. Set Analysis essentials
        2. Using Set Analysis
        3. Alternate States
        4. What-If Analysis
          1. Using input box
        5. The last step
        6. Summary
      14. 7. Securing Your Application
        1. Section Access essentials
        2. Implementing Section Access
          1. Using OMIT
          2. Using reduction
        3. Summary
      15. 8. Application Deployment
        1. QlikView architecture essentials
        2. Client Access Licenses (CALs)
        3. QlikView application deployment
        4. QlikView server structure
        5. Summary
      16. Index