Index

A

• Above function / How it works…
• Active Directory
  • users, reading from / Reading users from Active Directory, How to do it..., How it works...
• Admins
  • values, making available to / Making all values available to Admins and Managers, How to do it…, There's more…
• Advanced styling mode / How it works…
• AGGR
  • used, for calculating maximum value percentage / Using AGGR to calculate the percentage of the maximum value, How to do it..., How it works...
  • using, to resolve Sums of Rows issue / Using AGGR to resolve a "Sum of Rows" issue, How to do it..., There's more...
• AllowMacroFunctionInExpressions option / How it works…
• alternate states
  • using, in Set Analysis / Using alternate states with Set Analysis, How to do it..., There's more...
• Alt function / How it works…, Handling null in numeric fields or calculations, How it works…, There's more…, How it works...
• AND Mode
  • using, in listboxes / Using the AND mode in listboxes, How to do it..., How it works...

B

• bar chart
  • about / Creating custom pop-up labels on a bar chart
  • custom pop up labels, creating / Creating custom pop-up labels on a bar chart, How to do it…
  • creating, steps / How to do it…
  • creating, in straight table / Creating a bar chart in a straight table, How to do it…
  • secondary dimension, creating / Creating a secondary dimension in a bar chart, How to do it…, How it works…
• box plot chart
  • creating, for simple data set / Creating a box plot chart for a simple data set, How to do it…, How it works…
  • creating, wizard used / Using the wizard to create a box plot chart, How to do it…, How it works…, There's more…
• budget
  • creating, for store / Creating a Key/Link table in QlikView, Getting ready

C

• calculations
  • null, handling / Handling null in numeric fields or calculations, How to do it…, There's more…
• cell
  • custom formatting, design menus used / Using the design menus to custom format a cell, How to do it…, How it works…
• charts
  • about / Introduction
  • bar chart / Creating custom pop-up labels on a bar chart
  • box plot chart / Creating a box plot chart for a simple data set
  • Stephen Few bullet chart / Creating a "Stephen Few" bullet chart
  • modified bullet chart / Creating a modified bullet chart in a straight table
  • Redmond Aged Debt Profile chart / Creating a Redmond Aged Debt Profile chart, How to do it…
  • waterfall chart / Creating a waterfall chart
  • line chart / Replacing the legend in a line chart with labels on each line
  • scatter chart / Using redundant encoding with a scatter chart
  • pie chart / Staggering labels in a pie chart
  • creating, macro used / Creating a chart using a macro, How to do it…
  • VBS functions, using / Using VBS functions in charts, How to do it…
• chr function / How it works…
• COALESCE function / Handling null in numeric fields or calculations
• colormix
  • used, for creating colored Treemaps / Creating a colored treemap using colormix, How to do it..., How it works...
• color scheme
  • default selection color scheme, changing / Changing the default selection color scheme, How to do it…
  • default green color scheme, modifying / How to do it, How it works…
  • default gray color scheme, modifying / How to do it, How it works…
  • default white color scheme, modifying / How to do it, How it works…
• containers
  • using, as alternative to Multi Boxes / Using containers as an alternative to multiboxes, How to do it…, How it works…
• control chart
  • creating, Moving Range chart used / Creating a control chart using Moving Range, How to do it..., How it works...
• Count Distinct
  • avoiding, counter fields created for / Creating counter fields to avoid Count Distinct, How to do it…, How it works…
• counter fields
  • creating, to avoid Count Distinct / Creating counter fields to avoid Count Distinct, How to do it…, How it works…
• Count function / Creating counter fields to avoid Count Distinct
• CreateBarChart method / How it works…
• custom pop up labels
  • creating, on bar chart / Creating custom pop-up labels on a bar chart, How to do it…
  • working / How it works…

D

• data
  • exporting, to Word report / Extracting QlikView data to a Word report, How to do it…, How it works…
• data load
  • limiting, Exists used / Using Exists and Keep to limit the data load, How to do it..., How it works...
  • limiting, Keep used / Using Exists and Keep to limit the data load, How to do it..., How it works...
• data modeling
  • about / Introduction
• date-time value
  • consolidating, into quarter hour segments / Consolidating a date-time value into quarter hourly segments, How to do it…, There's more…
• Date field / How it works…
• date function / How it works…
• Date Island
  • Set Analysis, using / Using Set Analysis with a Date Island, How to do it..., How it works...
• dates
  • text, parsing to / Parsing text to numbers and dates, There's more…
  • financial periods, matching to / Matching financial periods to dates, How to do it..., How it works...
• Days360 function / Using VBS functions in charts
• design menus
  • using, to custom format cell / Using the design menus to custom format a cell, How to do it…, How it works…
  • order / Using the design menus to custom format a cell
  • custom format cell / Using the design menus to custom format a cell
• dimension / Introduction
• DirList function / How it works...
• display format
  • default display format, setting / Setting the default display format, How to do it..., How it works...
• Distinct clause / How it works...
• Distinct keyword / How it works...
• distinct values
  • number, reducing / Reducing the number of distinct values, Getting ready, How to do it…, How it works…
• distinguishedName field / How it works...
• Document Extensions
  • about / Introduction
• dollar expansion
  • using, in Set Analysis / Using dollar expansion in Set Analysis to enable from-date and to-date selection, How to do it..., How it works...
• dollar expression
  • used, for creating dynamic AGGR expression / Creating a dynamic AGGR expression for a Group dimension using Dollar Expansion, How to do it...
• dollar sign expansion
  • parameters, using / Using parameters in Dollar Sign Expansion, How it works...
• Dual
  • used, for handling period name sort / Using Dual to handle period name sorting, How it works…
• Dual function / How it works…, How it works…
• dynamic ad hoc analysis
  • creating, in QlikView / Creating dynamic ad hoc analysis in QlikView, How to do it…, How it works…, There's more…
• dynamic AGGR expression, Group dimension
  • creating, dollar expression used / Creating a dynamic AGGR expression for a Group dimension using Dollar Expansion, How to do it..., How it works...
• dynamic Part-to-Whole pie chart
  • creating, steps for / Creating a dynamic Part-to-Whole pie chart, How to do it..., There's more...

E

• Exists
  • using, to limit data load / Using Exists and Keep to limit the data load, How to do it..., How it works...
• expressions / Introduction
• Expressions tab / How to do it…
• ExRate field / How it works...
• extension
  • about / Introduction
  • HTML extension, creating / Creating a simple HTML extension, How to do it…, How it works…
  • HTML table extension, creating / How to do it…, How it works…
  • interactive extension, creating / How to do it…
  • external libraries, using / Using external libraries with extensions, How to do it…, How it works…
• external libraries
  • using, with extension / Using external libraries with extensions, How to do it…, How it works…

F

• # function / How it works…
• fact tables
  • concatenation / Concatenation of fact tables to avoid loops and synthetic keys, Getting ready, How to do it…, How it works...
• field
  • user access blocking, OMIT used / Blocking user access to a field using OMIT, How to do it…, There's more…
• fields
  • removing, with wildcard / Removing fields with a wildcard, How to do it..., There's more...
• FileList function / How it works...
• financial periods
  • matching, to dates / Matching financial periods to dates, How to do it..., There's more...
• flag fields
  • creating, to avoid Sum of If expression / Creating flag fields to avoid Sum of If and other inefficient expressions, How to do it…, How it works…, There's more…
• flags
  • creating, in script / Creating flags in the script, How to do it..., How it works..., There's more...
• From/To dates
  • dynamically filter by / How to do it…, How it works…

G

• Gantt chart
  • creating for dashboard, Interval Match used / Creating a simple Gantt for a dashboard using Interval Match, How to do it..., How it works...
• Gauge Settings button / How to do it…
• GetFieldSelections function / How it works…
• GetSubFolders subroutine / How it works...
• gray color scheme
  • default gray color scheme, changing / Modifying the green, white, and gray selection color schemes, How to do it, How it works…
  • on QlikView Server, modifying / Modifying the green, white, and gray selection color schemes in QlikView Server, How it works…
• green color scheme
  • default green color scheme, changing / How to do it, There's more…
  • on QlikView Server, modifying / Modifying the green, white, and gray selection color schemes in QlikView Server, How it works…
• Group dimension
  • dynamic AGGR expression creating, dollar expression used / Creating a dynamic AGGR expression for a Group dimension using Dollar Expansion, How to do it..., How it works...

H

• highest value, range
  • calculating / Calculating the lowest or highest value in a range, How to do it…, How it works…, There's more…
• HTML extension
  • creating / Creating a simple HTML extension, How to do it…, How it works…
• HTML table extension
  • creating / Creating a simple HTML table, How to do it…, How it works…

I

• InsertChartToWord method / How it works…
• InsertTableToWord method / How it works…
• interactive extension
  • creating / How to do it…, There's more…
• Interval Match
  • using, to create Gantt chart for dashboard / Creating a simple Gantt for a dashboard using Interval Match, How to do it..., How it works...
• IntervalMatch function / How it works...
• IsNull
  • replacing / Replacing IsNull, How to do it...
• ISNULL function / Handling null in numeric fields or calculations

J

• Join load / How it works...

K

• Keep
  • using, to limit data load / Using Exists and Keep to limit the data load, How to do it...
• Key table
  • creating, in QlikView / Creating a Key/Link table in QlikView, Getting ready, How to do it…, How it works...
• Key tables
  • avoiding, Sets used / Using Sets to avoid key tables, How to do it..., How it works...
• Kimball style star schema / There's more…

L

• labels
  • staggering, in pie chart / Staggering labels in a pie chart, How to do it…, How it works…
• layout
  • best practices / Introduction
  • default layout option, changing / Changing the default object layout options, How to do it…, How it works…
• line chart
  • legend, replacing / Replacing the legend in a line chart with labels on each line, How to do it…, How it works…
  • creating, with variable width lines / Creating a line chart with variable width lines, How to do it…, How it works…
• Line Style property / How it works…
• Link table
  • creating, in QlikView / Creating a Key/Link table in QlikView, Getting ready, How to do it…, How it works...
• listboxes
  • AND Mode, using / Using the AND mode in listboxes, How to do it..., How it works...
• Load Order sort option / Setting the default sort order
• lowest value, range
  • calculating / Calculating the lowest or highest value in a range, How to do it…, How it works…, There's more…

M

• macro
  • used, for creating charts / Creating a chart using a macro, How to do it…
• Managers
  • values, making available to / Making all values available to Admins and Managers, How to do it…, There's more…
• maximum value percentage
  • calculating, AGGR used / Using AGGR to calculate the percentage of the maximum value, How to do it..., How it works...
• modified bullet chart
  • creating, in straight table / Creating a modified bullet chart in a straight table, How to do it…, There's more…
• Moving Range chart
  • creating / Creating a Moving Range chart, How to do it..., There's more...
  • used, for creating control chart / Creating a control chart using Moving Range, How to do it..., How it works...
• Multi Boxes
  • containers, using as alternative to / Using containers as an alternative to multiboxes, How to do it…, How it works…
• multiple subfolders
  • handling, in script / Handling multiple subfolders in a script, How to do it..., How it works...

N

• NoOfFields function / How it works...
• null
  • handling, in numeric fields / Handling null in numeric fields or calculations, How to do it…, There's more…
  • handling, in calculations / Handling null in numeric fields or calculations, How to do it…, There's more…
• numbers
  • text, parsing to / Parsing text to numbers and dates, There's more…
• numeric fields
  • null, handling / Handling null in numeric fields or calculations, How to do it…, There's more…

O

• OMIT
  • used, for blocking user access to field / Blocking user access to a field using OMIT, How to do it…, There's more…
• Only() function / How it works…
• Override Document Settings option / How to do it…

P

• parallel coordinates
  • about / Brushing parallel coordinates
  • brushing / Getting ready, How to do it…, How it works…
• parameters
  • using, in dollar sign expansion / Using parameters in Dollar Sign Expansion, How to do it...
• partial reload
  • in script, handling / Handling partial reload in the script, How to do it..., How it works...
• PDF
  • reports printing, PDFCreator used / Printing reports to PDF using PDFCreator, How to do it…
• PDFCreator
  • used, for printing reports to PDF / Printing reports to PDF using PDFCreator, How to do it…
• Peek
  • about / Using Peek and Previous to calculate against loaded records
  • data, loading / Getting ready
  • using, to calculate against loaded records / How to do it..., How it works...
• performance
  • denormalizing for / How to do it…, There's more…
• period name sort
  • handling, Dual used / Using Dual to handle period name sorting, How to do it…
• pie chart
  • labels, staggering / Staggering labels in a pie chart, How to do it…
  • labelling, to replace legend / Labeling a pie chart to replace the legend, How to do it…, How it works…
• pie charts
  • dynamic Part-to-Whole pie chart, creating / Creating a dynamic Part-to-Whole pie chart, How to do it..., How it works..., There's more...
• pivot table
  • top 3 values, displaying / How to do it..., How it works...
• positive numbers
  • returning, RangeMax used / Using RangeMax to return only positive numbers, How to do it...
• Presentation tab / How to do it…
• Previous
  • about / Using Peek and Previous to calculate against loaded records, Getting ready
  • data, loading / Getting ready
  • using, to calculate against loaded records / How to do it..., How it works...

Q

• QilkView
  • dynamic ad hoc analysis, creating / Creating dynamic ad hoc analysis in QlikView
• QlikView
  • default layout option, changing / Changing the default object layout options, How to do it…, How it works…
  • default selection color scheme, changing / Changing the default selection color scheme, How to do it…
  • coding / Introduction
  • data, exporting to Word report / Extracting QlikView data to a Word report, How to do it…, How it works…
  • data modeling / Introduction
  • Link table, creating / Creating a Key/Link table in QlikView, Getting ready, How to do it…, How it works...
  • Key table, creating / Creating a Key/Link table in QlikView, Getting ready, How to do it…, How it works...
  • extensions / Introduction
  • functions / Introduction
  • script / Introduction
  • performance, improving / Introduction
  • security / Introduction
• QlikView Server
  • gray color scheme, modifying / Modifying the green, white, and gray selection color schemes in QlikView Server, How to do it…
  • white color scheme, modifying / Modifying the green, white, and gray selection color schemes in QlikView Server, How to do it…
  • green color scheme, modifying / Modifying the green, white, and gray selection color schemes in QlikView Server, How to do it…
• quarter hour segments
  • date-time value, consolidating into / Consolidating a date-time value into quarter hourly segments, How to do it…, There's more…
• QuilkView
  • dynamic ad hoc analysis, creating / How to do it…, How it works…, There's more…
• QVD storing
  • subroutine used / Storing and dropping using a subroutine, How to do it...

R

• range
  • lowest value, calcualting / Calculating the lowest or highest value in a range, How to do it…, How it works…
  • highest value, calcualting / Calculating the lowest or highest value in a range, How to do it…, How it works…
• RangeMax
  • using, to return positive numbers / Using RangeMax to return only positive numbers, How to do it..., How it works..., There's more...
• RangeMax function / How it works...
• RangeSum
  • using, to calculate rolling totals / Using RangeSum to calculate a rolling total in a multidimension table, How to do it..., How it works...
• Redmond Aged Debt Profile chart
  • creating / Creating a Redmond Aged Debt Profile chart, How to do it…
• reports
  • printing to PDF, PDFCreator used / Printing reports to PDF using PDFCreator, How to do it…
• Representation property / How to do it…
• results
  • values excluding, Set operators used / Using Set operators to exclude values from results, How to do it..., How it works..., There's more...
• rolling totals
  • calculating, RangeSum used / Using RangeSum to calculate a rolling total in a multidimension table, How to do it..., How it works...
• RowNo() function / How it works…

S

• scatter chart
  • redundant encoding, using / Using redundant encoding with a scatter chart, How to do it…, There's more…
• script
  • flags, creating / Creating flags in the script, How to do it..., How it works...
  • partial reload, handling / Handling partial reload in the script, How to do it...
  • multiple subfolders, handling / Handling multiple subfolders in a script, How to do it...
• Section Access
  • about / Section Access gotchas, Getting ready, How to do it…
  • gotchas / How it works…
• SelectRow function / How it works…
• Set Analysis
  • dollar expansion, using / Using dollar expansion in Set Analysis to enable from-date and to-date selection, How to do it..., How it works...
  • alternate states, using / Using alternate states with Set Analysis, How to do it..., There's more...
  • using, with Date Island / Using Set Analysis with a Date Island, How to do it..., How it works...
• Set operators
  • used, for excluding values from results / Using Set operators to exclude values from results, How to do it..., How it works..., There's more...
• Sets
  • used, for avoiding Key tables / Using Sets to avoid key tables, How to do it..., How it works...
• Show Caption option / How to do it…
• Show Grid option / How to do it…
• Show Legend option / How to do it…, How to do it…
• simple data set
  • box plot chart, creating / Creating a box plot chart for a simple data set, How to do it…, How it works…
• Simple mode / How it works…
• sort order
  • default sort order, setting / Setting the default sort order, How to do it...
• Standard Deviation
  • used, for creating Statistical Control Chart / Creating a Statistical Control Chart using Standard Deviation, Getting ready, How it works..., There's more...
• Static Max option / How to do it…
• Static Max setting / How it works…
• Statistical Control Chart
  • creating, Standard Deviation used / Creating a Statistical Control Chart using Standard Deviation, Getting ready, How to do it..., There's more...
• Stephen Few bullet chart
  • about / Creating a "Stephen Few" bullet chart
  • creating / Creating a "Stephen Few" bullet chart, How to do it…
  • working / How it works…
• StockStore field / How it works...
• straight table
  • modified bullet chart, creating / Creating a modified bullet chart in a straight table, How to do it…, There's more…
  • bar chart, creating / Creating a bar chart in a straight table, How to do it…
• sub-URL
  • getting, TableWizard used / Getting a sub-URL using the Table wizard, How to do it...
• SubField function / How it works...
• subfolders
  • multiple subfolders in script, handling / Handling multiple subfolders in a script, How to do it...
• subroutine
  • used, for QVD storing / Storing and dropping using a subroutine
  • used, for dropping table / How to do it..., There's more...
  • used, for storing QVD / How to do it..., There's more...
• Sum (FactValue * Flag) function / There's more…
• Sum function / Creating counter fields to avoid Count Distinct
• Sum of If expression
  • avoiding, flag fields created for / Creating flag fields to avoid Sum of If and other inefficient expressions, How to do it…, How it works…, There's more…
• Sums of Rows issue
  • resolving, AGGR used / Using AGGR to resolve a "Sum of Rows" issue, How to do it..., There's more...

T

• table, dropping
  • subroutine used / How to do it...
• Table wizard
  • used, for getting sub-URL / Getting a sub-URL using the Table wizard, How to do it..., There's more...
• text
  • parsing, to numbers / Parsing text to numbers and dates, How to do it…, There's more…
  • parsing, to dates / Parsing text to numbers and dates, Getting ready, There's more…
• TOTAL
  • about / Using TOTAL to calculate the percentage of total and subtotal
  • used, for calculating total percentage / How to do it..., How it works...
  • used, for calculating subtotal percentage / How to do it..., How it works...
• Trace
  • about / Keeping a trace on things
  • using / How to do it..., How it works...
• Treemaps
  • colored Treemaps creating, colormix used / Creating a colored treemap using colormix, How to do it..., How it works...

U

• user
  • field access blocking, OMIT used / Blocking user access to a field using OMIT, How to do it…, There's more…
• UserPreferences object / How it works…
• users
  • reading, from Active Directory / Reading users from Active Directory, How to do it...

V

• values
  • excluding from results, Set operators used / Using Set operators to exclude values from results, How to do it..., How it works..., There's more...
  • distinct values number, reducing / Reducing the number of distinct values, Getting ready, How to do it…, How it works…
  • making, available to Admins / Making all values available to Admins and Managers, How to do it…, There's more…
  • making, available to Managers / Making all values available to Admins and Managers, How to do it…, There's more…
• Values on Data Points option / How it works…
• variable width lines
  • line chart, creating with / Creating a line chart with variable width lines, How to do it…, How it works…
• VBS functions
  • using, in charts / Using VBS functions in charts, How to do it…

W

• waterfall chart
  • creating / Creating a waterfall chart, How to do it…, How it works…
• white color scheme
  • default white color scheme, changing / Modifying the green, white, and gray selection color schemes, How to do it, How it works…
  • on QlikView Server, modifying / Modifying the green, white, and gray selection color schemes in QlikView Server, How it works…
• wildcard
  • fields, removing with / Removing fields with a wildcard, How to do it..., There's more...
• wizard
  • used, for box plot chart creating / Using the wizard to create a box plot chart, How to do it…, How it works…, There's more…
• Word report
  • data, exporting to / Extracting QlikView data to a Word report, How to do it…, How it works…

X

• X-Axis / Introduction
• XmR Chart / There's more...

Y

• Y-Axis / Introduction
• Year To Date function
  • dynamic calculation / Calculating Year To Date dynamically, How to do it…, How it works…