QlikView for Developers Cookbook

QlikView for Developers Cookbook
eBook: $26.99
Formats: PDF, PacktLib, ePub and Mobi formats
save 15%!
Print + free eBook + free PacktLib access to the book: $71.98    Print cover: $44.99
save 37%!
Free Shipping!
UK, US, Europe and selected countries in Asia.
Also available on:
Table of Contents
Sample Chapters
  • 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

Book Details

Language : English
Paperback : 290 pages [ 235mm x 191mm ]
Release Date : June 2013
ISBN : 1782179739
ISBN 13 : 9781782179733
Author(s) : Stephen Redmond
Topics and Technologies : All Books, Big Data and Business Intelligence, Cookbooks, Enterprise

Table of Contents

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

                        Stephen Redmond

                        Stephen Redmond is CTO of CapricornVentis Limited ( http://www.capventis.com ), a QlikView Elite Partner. He is the author of several books, including  QlikView for Developers Cookbook ,  Packt Publishing , and the popular DevLogix series for SalesLogix developers.

                        In 2006, after working for many years with CRM systems, reporting and analysis solutions, and data integration, Stephen started working with QlikView. Since then, CapricornVentis have become QlikView's top partner in the UK and Ireland territory, and with Stephen at the head of the team, they have implemented QlikView in a wide variety of enterprises and large-business customers, across a wide range of sectors, from public sector to financial services to large retailers.

                        Stephen regularly contributes to online forums, including the Qlik Community. His QlikView blog is at http://www.qliktips.com , and you can follow him on Twitter (@stephencredmond), where he tweets about QlikView, BI, data visualization, technology in general, and occasionally marathon running.

                        Code Downloads

                        Download the code and support files for this book.

                        Submit Errata

                        Please let us know if you have found any errors not listed on this list by completing our errata submission form. Our editors will check them and add them to this list. Thank you.


                        - 3 submitted: last submission 08 May 2014

                        Errata Type: Code Page No: 60

                        In the given table, the expression mentioned for the City dimension has a missing closing bracket ")".
                        It should be:
                              GetFieldSelections(%Dimensions, '|'),

                        Errata Type: Technical Errata Page: 121

                        In the example, Using RangeSum to calculate a rolling total in a multidimension table (chapter 4), the script has the dimensions "country, city, Sales and Orders", the first instruction is:
                        1. Create a new pivot table with year and country as dimensions.

                        It is suggested that you use the next script (page 123) for this example.

                        Errata type: Grammar | Page number: Front Matter (6)


                        In the author's acknowledgment, the line: "None of what I do would be possible with them."

                        Should read "None of what I do would be possible without them."

                        Sample chapters

                        You can view our sample chapters and prefaces of this title on PacktLib or download sample chapters in PDF format.

                        Frequently bought together

                        QlikView for Developers Cookbook +    Haskell Data Analysis Cookbook =
                        50% Off
                        the second eBook
                        Price for both: £26.35

                        Buy both these recommended eBooks together and get 50% off the cheapest eBook.

                        What you will learn from this book

                        • Use QlikView charts to create more advanced visualizations
                        • Layout your screen and use different color schemes
                        • Get to grips with set analysis
                        • Use Total and AGGR for advanced aggregations
                        • Use macros to perform advanced tasks
                        • Overcome data modelling challenges
                        • Use some of the most useful functions in QlikView
                        • Write great script
                        • Improve the performance of your application
                        • Secure your application

                        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.


                        The recipes in this Cookbook provide a concise yet practical guide on how to become an excellent QlikView developer. The book begins with intermediate level recipes and then moves on to more complex recipes in an incremental manner.

                        Who this book is for

                        This book is for anyone who has either attended QlikView Developer training or has taught themselves QlikView from books or online sources. You might be working for a QlikView customer, partner, or even QlikView themselves (or want to!) and want to improve your QlikView skills.

                        Code Download and Errata
                        Packt Anytime, Anywhere
                        Register Books
                        Print Upgrades
                        eBook Downloads
                        Video Support
                        Contact Us
                        Awards Voting Nominations Previous Winners
                        Judges Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software
                        Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software