QlikView for Developers Cookbook电子书

QlikView for Developers Cookbook

Table of Contents

QlikView for Developers Cookbook

Credits

Foreword

About the Author

About the Reviewers

www.PacktPub.com

Support files, eBooks, discount offers and more

Why Subscribe?

Free Access for Packt account holders

Instant Updates on New Packt Books

Preface

What this book covers

What you need for this book

Who this book is for

Conventions

Reader feedback

Customer support

Downloading the example code

Errata

Piracy

Questions

1. Charts

Introduction

Creating custom pop-up labels on a bar chart

Getting ready

How to do it…

How it works…

There's more…

Creating a box plot chart for a simple data set

Getting ready

How to do it…

How it works…

There's more…

See also

Using the wizard to create a box plot chart

Getting ready

How to do it…

How it works…

There's more…

See also

Creating a "Stephen Few" bullet chart

Getting ready

How to do it…

How it works…

There's more…

See also

Creating a modified bullet chart in a straight table

Getting ready

How to do it…

How it works…

There's more…

See also

Creating a bar chart in a straight table

Getting ready

How to do it…

How it works…

There's more…

See also

Creating a Redmond Aged Debt Profile chart

Getting ready

How to do it…

How it works…

There's more…

See also

Creating a waterfall chart

Getting ready

How to do it…

How it works…

There's more…

Replacing the legend in a line chart with labels on each line

Getting ready

How to do it…

How it works…

There's more…

See also

Creating a secondary dimension in a bar chart

Getting ready

How to do it…

How it works…

There's more…

Creating a line chart with variable width lines

Getting ready

How to do it…

How it works…

There's more…

Brushing parallel coordinates

Getting ready

How to do it…

How it works…

There's more…

See also

Using redundant encoding with a scatter chart

Getting ready

How to do it…

How it works…

There's more…

Staggering labels in a pie chart

Getting ready

How to do it…

How it works…

There's more…

Creating dynamic ad hoc analysis in QlikView

Getting ready

How to do it…

How it works…

There's more…

2. Layout

Introduction

Changing the default object layout options

Getting ready

How to do it…

How it works…

See also

Changing the default selection color scheme

Getting ready

How to do it…

How it works…

There's more…

See also

Modifying the green, white, and gray selection color schemes

Getting ready

How to do it

How it works…

There's more…

See also

Modifying the green, white, and gray selection color schemes in QlikView Server

Getting ready

How to do it…

How it works…

See also

Using containers as an alternative to multiboxes

Getting ready

How to do it…

How it works…

Using the design menus to custom format a cell

Getting ready

How to do it…

How it works…

There's more…

3. Set Analysis

Introduction

Using dollar expansion in Set Analysis to enable from-date and to-date selection

Getting ready

How to do it...

How it works...

Using alternate states with Set Analysis

Getting ready

How to do it...

How it works...

There's more...

See Also

Using Set operators to exclude values from results

Getting ready

How to do it...

How it works...

There's more...

Using Set Analysis with a Date Island

Getting ready

How to do it...

How it works...

There's more...

See Also

Using Sets to avoid key tables

Getting ready

How to do it...

How it works...

There's more...

4. Advanced Aggregations

Introduction

Using TOTAL to calculate the percentage of total and subtotal

Getting ready

How to do it...

How it works...

There's more...

Using AGGR to calculate the percentage of the maximum value

Getting ready

How to do it...

How it works...

There's more...

Using AGGR to resolve a "Sum of Rows" issue

Getting ready

How to do it...

How it works...

There's more...

See also

Creating a dynamic AGGR expression for a Group dimension using Dollar Expansion

Getting ready

How to do it...

How it works...

See also

Using RangeMax to return only positive numbers

Getting ready

How to do it...

How it works...

There's more...

See also

Creating a dynamic Part-to-Whole pie chart

Getting ready

How to do it...

How it works...

There's more...

See also

Creating a colored treemap using colormix

Getting ready

How to do it...

How it works...

There's more...

Using RangeSum to calculate a rolling total in a multidimension table

Getting ready

How to do it...

How it works...

There's more...

Showing only the top 3 values in a pivot table

Getting ready

How to do it...

How it works...

There's more...

Creating a Statistical Control Chart using Standard Deviation

Getting ready

How to do it...

How it works...

There's more...

See also

Creating a Moving Range chart

Getting ready

How to do it...

How it works...

There's more...

See also

Creating a control chart using Moving Range

Getting ready

How to do it...

How it works...

There's more...

See also

5. Advanced Coding

Introduction

Extracting QlikView data to a Word report

Getting ready

How to do it…

How it works…

There's more…

See also

Printing reports to PDF using PDFCreator

Getting ready

How to do it…

How it works…

See also

Creating a chart using a macro

Getting ready

How to do it…

How it works…

There's more…

Using VBS functions in charts

Getting ready

How to do it…

How it works…

There's more…

6. Data Modeling

Introduction

Concatenation of fact tables to avoid loops and synthetic keys

Getting ready

How to do it…

How it works...

There's more...

See also

Creating a Key/Link table in QlikView

Getting ready

How to do it…

How it works...

There's more...

See also

7. Extensions

Introduction

Creating a simple HTML extension

Getting ready

How to do it…

How it works…

There's more…

See also

Creating a simple HTML table

Getting ready

How to do it…

How it works…

There's more…

See also

Creating an interactive extension

Getting ready

How to do it…

How it works…

There's more…

See also

Using external libraries with extensions

Getting ready

How to do it…

How it works…

There's more…

See also

8. Useful Functions

Introduction

Handling null in numeric fields or calculations

Getting ready

How to do it…

How it works…

There's more…

See also

Using Dual to handle period name sorting

How to do it…

How it works…

There's more…

See also

Parsing text to numbers and dates

Getting ready

How to do it…

How it works…

There's more…

See also

Calculating Year To Date dynamically

Getting ready

How to do it…

How it works…

There's more…

Labeling a pie chart to replace the legend

Getting ready

How to do it…

How it works…

There's more…

See also

Calculating the lowest or highest value in a range

Getting ready

How to do it…

How it works…

There's more…

Consolidating a date-time value into quarter hourly segments

Getting ready

How to do it…

How it works…

There's more…

Dynamically filtering by From/To dates

Getting ready

How to do it…

How it works…

There's more…

9. Script

Introduction

Creating flags in the script

Getting ready

How to do it...

How it works...

There's more...

Replacing IsNull

Getting ready

How to do it...

How it works...

There's more...

Storing and dropping using a subroutine

Getting ready

How to do it...

How it works...

There's more...

See also

Keeping a trace on things

Getting ready

How to do it...

How it works...

There's more...

See also

Using the AND mode in listboxes

Getting ready

How to do it...

How it works...

There's more...

Using Exists and Keep to limit the data load

Getting ready

How to do it...

How it works...

There's more...

Setting the default display format

Getting ready

How to do it...

How it works...

There's more...

See also

Setting the default sort order

Getting ready

How to do it...

How it works...

There's more...

See also

Matching financial periods to dates

Getting ready

How to do it...

How it works...

There's more...

See also

Handling partial reload in the script

Getting ready

How to do it...

How it works...

There's more...

Using Peek and Previous to calculate against loaded records

Getting ready

How to do it...

How it works...

There's more...

Creating a simple Gantt for a dashboard using Interval Match

Getting ready

How to do it...

How it works...

See also

Reading users from Active Directory

Getting ready

How to do it...

How it works...

Getting a sub-URL using the Table wizard

Getting ready

How to do it...

How it works...

There's more...

Using parameters in Dollar Sign Expansion

Getting ready

How to do it...

How it works...

Removing fields with a wildcard

Getting ready

How to do it...

How it works...

There's more...

Handling multiple subfolders in a script

Getting ready

How to do it...

How it works...

10. Improving Performance

Introduction

Reducing the number of distinct values

Getting ready

How to do it…

How it works…

There's more…

See also

Creating counter fields to avoid Count Distinct

Getting ready

How to do it…

How it works…

There's more…

See also

Creating flag fields to avoid Sum of If and other inefficient expressions

Getting ready

How to do it…

How it works…

There's more…

See also

Denormalizing for performance

Getting ready

How to do it…

How it works…

There's more…

See also

11. Security

Introduction

Section Access gotchas

Getting ready

How to do it…

How it works…

There's more…

See also

Blocking user access to a field using OMIT

Getting ready

How to do it…

How it works…

There's more…

See also

Making all values available to Admins and Managers

Getting ready

How to do it…

How it works…

There's more…

See also

Index