會員

QlikView for Developers Cookbook

更新時(shí)間：2021-08-13 17:08:45

開會員，本書免費(fèi)讀 >

TherecipesinthisCookbookprovideaconciseyetpracticalguideonhowtobecomeanexcellentQlikViewdeveloper.Thebookbeginswithintermediatelevelrecipesandthenmovesontomorecomplexrecipesinanincrementalmanner.ThisbookisforanyonewhohaseitherattendedQlikViewDevelopertrainingorhastaughtthemselvesQlikViewfrombooksoronlinesources.YoumightbeworkingforaQlikViewcustomer,partner,orevenQlikViewthemselves(orwantto!)andwanttoimproveyourQlikViewskills.

目錄(111章)

倒序

封面
版權(quán)信息
Credits
Foreword
About the Author
About the Reviewers
www.PacktPub.com
Preface
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
Index 更新時(shí)間：2021-08-13 17:08:45

官术网_书友最值得收藏!

QlikView for Developers Cookbook