You are previewing QlikView for Developers Cookbook.
O'Reilly logo
QlikView for Developers Cookbook

Book Description

Take your QlikView training to the next level with this brilliant book that’s packed with recipes which progress from intermediate to advanced. The step-by step-approach makes learning easy and enjoyable.

  • Learn beyond QlikView training

  • Discover QlikView Advanced GUI development, advanced scripting, complex data modelling issues, and much more

  • Accelerate the growth of your QlikView developer ability

  • Based on over 7 years’ experience of QlikView development

  • Written in a handy Cookbook style with each recipe as a self-contained learning module

  • In Detail

    QlikView has been around since 1993, but has only really taken off in recent years as a leader in the in-memory BI space and, more recently, in the data discovery area. QlikView features the ability to consolidate relevant data from multiple sources into a single application, as well as an associative data model to allow you to explore the data to a way your brain works, state-of-the-art visualizations, dashboard, analysis and reports, and mobile data access.

    QlikView for Developers Cookbook builds on your initial training and experiences with QlikView to help you become a better developer. This book features plenty of hands-on examples of many challenging functions.

    Assuming a basic understanding of QlikView development, this book provides a range of step-by-step exercises to teach you different subjects to help build your QlikView developer expertise.

    From advanced charting and layout to set analysis; from advanced aggregations through to scripting, performance, and security, this book will cover all the areas that you need to know about.

    The recipes in this book will give you a lot of the information that you need to become an excellent QlikView developer.

    Table of Contents

    1. QlikView for Developers Cookbook
      1. Table of Contents
      2. QlikView for Developers Cookbook
      3. Credits
      4. Foreword
      5. About the Author
      6. About the Reviewers
      7. 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
      8. 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
      9. 1. Charts
        1. Introduction
        2. Creating custom pop-up labels on a bar chart
          1. Getting ready
          2. How to do it…
          3. How it works…
          4. There's more…
        3. Creating a box plot chart for a simple data set
          1. Getting ready
          2. How to do it…
          3. How it works…
          4. There's more…
          5. See also
        4. Using the wizard to create a box plot chart
          1. Getting ready
          2. How to do it…
          3. How it works…
          4. There's more…
          5. See also
        5. Creating a "Stephen Few" bullet chart
          1. Getting ready
          2. How to do it…
          3. How it works…
          4. There's more…
          5. See also
        6. Creating a modified bullet chart in a straight table
          1. Getting ready
          2. How to do it…
          3. How it works…
          4. There's more…
          5. See also
        7. Creating a bar chart in a straight table
          1. Getting ready
          2. How to do it…
          3. How it works…
          4. There's more…
          5. See also
        8. Creating a Redmond Aged Debt Profile chart
          1. Getting ready
          2. How to do it…
          3. How it works…
          4. There's more…
          5. See also
        9. Creating a waterfall chart
          1. Getting ready
          2. How to do it…
          3. How it works…
          4. There's more…
        10. Replacing the legend in a line chart with labels on each line
          1. Getting ready
          2. How to do it…
          3. How it works…
          4. There's more…
          5. See also
        11. Creating a secondary dimension in a bar chart
          1. Getting ready
          2. How to do it…
          3. How it works…
          4. There's more…
        12. Creating a line chart with variable width lines
          1. Getting ready
          2. How to do it…
          3. How it works…
          4. There's more…
        13. Brushing parallel coordinates
          1. Getting ready
          2. How to do it…
          3. How it works…
          4. There's more…
          5. See also
        14. Using redundant encoding with a scatter chart
          1. Getting ready
          2. How to do it…
          3. How it works…
          4. There's more…
        15. Staggering labels in a pie chart
          1. Getting ready
          2. How to do it…
          3. How it works…
          4. There's more…
        16. Creating dynamic ad hoc analysis in QlikView
          1. Getting ready
          2. How to do it…
          3. How it works…
          4. There's more…
      10. 2. Layout
        1. Introduction
        2. Changing the default object layout options
          1. Getting ready
          2. How to do it…
          3. How it works…
          4. See also
        3. Changing the default selection color scheme
          1. Getting ready
          2. How to do it…
          3. How it works…
          4. There's more…
          5. See also
        4. Modifying the green, white, and gray selection color schemes
          1. Getting ready
          2. How to do it
          3. How it works…
          4. There's more…
          5. See also
        5. Modifying the green, white, and gray selection color schemes in QlikView Server
          1. Getting ready
          2. How to do it…
          3. How it works…
          4. See also
        6. Using containers as an alternative to multiboxes
          1. Getting ready
          2. How to do it…
          3. How it works…
        7. Using the design menus to custom format a cell
          1. Getting ready
          2. How to do it…
          3. How it works…
          4. There's more…
      11. 3. Set Analysis
        1. Introduction
        2. Using dollar expansion in Set Analysis to enable from-date and to-date selection
          1. Getting ready
          2. How to do it...
          3. How it works...
        3. Using alternate states with Set Analysis
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
          5. See Also
        4. Using Set operators to exclude values from results
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
        5. Using Set Analysis with a Date Island
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
          5. See Also
        6. Using Sets to avoid key tables
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
      12. 4. Advanced Aggregations
        1. Introduction
        2. Using TOTAL to calculate the percentage of total and subtotal
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
        3. Using AGGR to calculate the percentage of the maximum value
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
        4. Using AGGR to resolve a "Sum of Rows" issue
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
          5. See also
        5. Creating a dynamic AGGR expression for a Group dimension using Dollar Expansion
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. See also
        6. Using RangeMax to return only positive numbers
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
          5. See also
        7. Creating a dynamic Part-to-Whole pie chart
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
          5. See also
        8. Creating a colored treemap using colormix
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
        9. Using RangeSum to calculate a rolling total in a multidimension table
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
        10. Showing only the top 3 values in a pivot table
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
        11. Creating a Statistical Control Chart using Standard Deviation
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
          5. See also
        12. Creating a Moving Range chart
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
          5. See also
        13. Creating a control chart using Moving Range
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
          5. See also
      13. 5. Advanced Coding
        1. Introduction
        2. Extracting QlikView data to a Word report
          1. Getting ready
          2. How to do it…
          3. How it works…
          4. There's more…
          5. See also
        3. Printing reports to PDF using PDFCreator
          1. Getting ready
          2. How to do it…
          3. How it works…
          4. See also
        4. Creating a chart using a macro
          1. Getting ready
          2. How to do it…
          3. How it works…
          4. There's more…
        5. Using VBS functions in charts
          1. Getting ready
          2. How to do it…
          3. How it works…
          4. There's more…
      14. 6. Data Modeling
        1. Introduction
        2. Concatenation of fact tables to avoid loops and synthetic keys
          1. Getting ready
          2. How to do it…
          3. How it works...
          4. There's more...
          5. See also
        3. Creating a Key/Link table in QlikView
          1. Getting ready
          2. How to do it…
          3. How it works...
          4. There's more...
          5. See also
      15. 7. Extensions
        1. Introduction
        2. Creating a simple HTML extension
          1. Getting ready
          2. How to do it…
          3. How it works…
          4. There's more…
          5. See also
        3. Creating a simple HTML table
          1. Getting ready
          2. How to do it…
          3. How it works…
          4. There's more…
          5. See also
        4. Creating an interactive extension
          1. Getting ready
          2. How to do it…
          3. How it works…
          4. There's more…
          5. See also
        5. Using external libraries with extensions
          1. Getting ready
          2. How to do it…
          3. How it works…
          4. There's more…
          5. See also
      16. 8. Useful Functions
        1. Introduction
        2. Handling null in numeric fields or calculations
          1. Getting ready
          2. How to do it…
          3. How it works…
          4. There's more…
          5. See also
        3. Using Dual to handle period name sorting
          1. How to do it…
          2. How it works…
          3. There's more…
          4. See also
        4. Parsing text to numbers and dates
          1. Getting ready
          2. How to do it…
          3. How it works…
          4. There's more…
          5. See also
        5. Calculating Year To Date dynamically
          1. Getting ready
          2. How to do it…
          3. How it works…
          4. There's more…
        6. Labeling a pie chart to replace the legend
          1. Getting ready
          2. How to do it…
          3. How it works…
          4. There's more…
          5. See also
        7. Calculating the lowest or highest value in a range
          1. Getting ready
          2. How to do it…
          3. How it works…
          4. There's more…
        8. Consolidating a date-time value into quarter hourly segments
          1. Getting ready
          2. How to do it…
          3. How it works…
          4. There's more…
        9. Dynamically filtering by From/To dates
          1. Getting ready
          2. How to do it…
          3. How it works…
          4. There's more…
      17. 9. Script
        1. Introduction
        2. Creating flags in the script
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
        3. Replacing IsNull
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
        4. Storing and dropping using a subroutine
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
          5. See also
        5. Keeping a trace on things
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
          5. See also
        6. Using the AND mode in listboxes
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
        7. Using Exists and Keep to limit the data load
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
        8. Setting the default display format
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
          5. See also
        9. Setting the default sort order
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
          5. See also
        10. Matching financial periods to dates
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
          5. See also
        11. Handling partial reload in the script
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
        12. Using Peek and Previous to calculate against loaded records
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
        13. Creating a simple Gantt for a dashboard using Interval Match
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. See also
        14. Reading users from Active Directory
          1. Getting ready
          2. How to do it...
          3. How it works...
        15. Getting a sub-URL using the Table wizard
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
        16. Using parameters in Dollar Sign Expansion
          1. Getting ready
          2. How to do it...
          3. How it works...
        17. Removing fields with a wildcard
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
        18. Handling multiple subfolders in a script
          1. Getting ready
          2. How to do it...
          3. How it works...
      18. 10. Improving Performance
        1. Introduction
        2. Reducing the number of distinct values
          1. Getting ready
          2. How to do it…
          3. How it works…
          4. There's more…
          5. See also
        3. Creating counter fields to avoid Count Distinct
          1. Getting ready
          2. How to do it…
          3. How it works…
          4. There's more…
          5. See also
        4. Creating flag fields to avoid Sum of If and other inefficient expressions
          1. Getting ready
          2. How to do it…
          3. How it works…
          4. There's more…
          5. See also
        5. Denormalizing for performance
          1. Getting ready
          2. How to do it…
          3. How it works…
          4. There's more…
          5. See also
      19. 11. Security
        1. Introduction
        2. Section Access gotchas
          1. Getting ready
          2. How to do it…
          3. How it works…
          4. There's more…
          5. See also
        3. Blocking user access to a field using OMIT
          1. Getting ready
          2. How to do it…
          3. How it works…
          4. There's more…
          5. See also
        4. Making all values available to Admins and Managers
          1. Getting ready
          2. How to do it…
          3. How it works…
          4. There's more…
          5. See also
      20. Index