Index

A

• Above function / Using inter-record and range functions
• additive facts
  • about / Summing with facts
• administrative metadata
  • about / Understanding what metadata is, Administrative metadata
• advanced aggregations
  • creating, with Aggr / Creating advanced aggregations with Aggr
  • Aggr, used for calculating control chart / Using Aggr to calculate a control chart
  • calculated dimensions / Calculated dimensions
  • nodistinct option, avoiding / No to nodistinct
• advanced search / Advanced search
• advanced Table File Wizard options
  • examining / Examining advanced Table File Wizard options
  • transformation step, enabling / Enabling a transformation step
  • Crosstable wizard, using / Using the Crosstable wizard
• affordances
  • about / Understanding affordances
• After function / Using inter-record and range functions
• Aggr
  • advanced aggregations, creating with / Creating advanced aggregations with Aggr
  • used, for calculating control chart / Using Aggr to calculate a control chart
• Aggregate operator / Transformers
• Aggr function / Creating advanced aggregations with Aggr
• Alternate States
  • used, as identifiers / Using Alternate States as identifiers
• ApplyMap
  • data optimization, by removing keys / Optimizing data by removing keys using ApplyMap
  • data, mapping with / Mapping data with ApplyMap
  • basic functionality, reviewing / Reviewing the basic functionality of ApplyMap
  • using, of Join with duplicate rows / Using ApplyMap instead of Join with duplicate rows
• artifacts
  • about / Understanding artifacts
  • Dataflows / Understanding artifacts
  • Connections / Understanding artifacts
  • Schemas / Understanding artifacts
  • Types / Understanding artifacts
  • Datascript Modules / Understanding artifacts
  • Lookup Tables / Understanding artifacts
  • Configurations / Understanding artifacts
  • Deployment Packages / Understanding artifacts
  • Operator Templates / Understanding artifacts
  • External Files / Understanding artifacts
  • Library References / Understanding artifacts
• As
  • used, for renaming fields / Renaming fields using As
• associative model
  • about / Associating data
• associative search / Associative search
• Atomic type
  • creating / Adding additional Atomic types
• audience
  • understanding / Understanding the audience
• AutoGenerate
  • about / AutoGenerate
• AutoGenerate() function / Generating fact table rows
• automatic interpretation, of searches
  • about / Automatic interpretation of searches
• AutoNumber function
  • used, for creating composite keys / Using the AutoNumber function
  / Executing transformers
• AutoNumber script function / Understanding synthetic keys

B

• basic concepts
  • reviewing / Reviewing basic concepts
• basic dataflow
  • creating / Creating and packaging a basic dataflow
  • packaging / Creating and packaging a basic dataflow
• basic data modeling
  • reviewing / Reviewing basic data modeling
  • data, associating / Associating data
  • tables, associating automatically / Automatically associating tables
  • facts, calculating at level of table / Realizing that facts are calculated at the level of their table
  • data, joining / Joining data
• basic performance tuning techniques
  • reviewing / Reviewing basic performance tuning techniques, Reviewing the basics
  • unneeded data, removing / Removing unneeded data
  • number of rows, reducing / Reducing the number of rows
  • number of columns, reducing / Reducing the number of columns
  • text keys, replacing with numbers / Replacing text keys with numbers
  • synthetic keys, resolving / Resolving synthetic keys
• Before function / Using inter-record and range functions
• Below function / Using inter-record and range functions
• bookmarks
  • about / Understanding bookmarks
  • saving / Saving a bookmark
  • options / Saving a bookmark
  • managing / Managing bookmarks
• bookmarks, options
  • Make this bookmark a document (server) bookmark / Saving a bookmark
  • Share Bookmark with Other Users / Saving a bookmark
  • Include Selections in Bookmark / Saving a bookmark
  • Make bookmark apply on top of current selection / Saving a bookmark
  • Include Layout State / Saving a bookmark
  • Include Scroll Position / Saving a bookmark
  • Include Input Field Values / Saving a bookmark
  • Info Text / Saving a bookmark
  • Pop-Up Message / Saving a bookmark
• Bottom function / Using inter-record and range functions
• branching, with conditional statements
  • about / Branching with conditional statements, A note about conditional functions
  • If $$$ Then $$$ ElseIf / If … Then … ElseIf
  • Switch $$$ Case / Switch … Case
  • When statement / When and Unless
  • Unless statement / When and Unless
• Buffer operator / Utility
• business process
  • about / Selecting the business process

C

• caching, QlikView
  • URL, for blog / Turning the cache off
• calculated dimensions / Calculated dimensions
• calculations
  • limiting / Limiting calculations
  • Sum of If / Sum of If
  • flag arithmetic / Flag arithmetic
  • variables, using for / Calculations using variables
  • data islands / Data islands
  • Set Analysis / Set Analysis
  • set / Explaining what we mean by a set
• calendar dimension
  • creating / Creating a calendar dimension
• Cartesian join
  • about / Cartesian joins
  • example / Cartesian joins
• chart calculation times
  • optimizing / Optimizing chart calculation times
• chart expressions
  • two-step process, following / Following the steps in a chart expression, Understanding when the steps happen in chart expressions
• chart performance, testing for different load options
  • about / Testing chart performance for different load options
  • cache, turning off / Turning the cache off
  • chart calculation time, examining for different scenarios / Examining the chart calculation time for different scenarios
  • performance, optimizing by creating counter fields / Optimizing performance by creating counter fields
  • performance, optimizing by combining fact tables / Optimizing performance by combining fact tables?
  • numbers, optimizing / Optimizing your numbers
• charts
  • educating with / Educating with charts
  • inventing / Inventing new charts
• charts, descriptive metadata
  • commenting in / Commenting in charts
  • dimensions, commenting / Commenting dimensions
  • expression comment, entering / Entering an expression comment
• charts selection
  • about / Choosing charts
  • categorical comparison / Categorical comparison
  • trend analysis / Trend analysis
  • measures, comparing / Comparing measures
  • low cardinality / Low cardinality, part-to-whole comparison
  • part-to-whole comparison / Low cardinality, part-to-whole comparison
  • tabular information / Tabular information
• classic star schema / Understanding star schemas
• code
  • reusing / Reusing code
• color
  • using / Using color, Color should have meaning
  • RAG system / What does RAG mean?
  • ink-to-data ratio / The ink-to-data ratio
• color blindness
  • about / Color blindness
• Color Brewer
  • URL / Color blindness
• ColumnNo function / Using inter-record and range functions
• common expressions
  • holding, variables used / Using variables to hold common expressions
• components, Expressor
  • Studio / Introducing Expressor
  • data integration engine / Introducing Expressor
  • repository / Introducing Expressor
• composite keys
  • creating / Creating composite keys
  • creating, string concatenation used / Using string concatenation
  • creating, Hash function used / Using one of the Hash functions
  • creating, AutoNumber function used / Using the AutoNumber function
• Composite type
  • creating / Creating Composite types
• Concat
  • using, with Dollar-sign Expansion / Using Concat with Dollar-sign Expansion
• Concatenate
  • reviewing / Reviewing Concatenate
  • versus Join / Differentiating Concatenate and Join
  • dissimilar files, loading with / Loading dissimilar files with Concatenate and For Each
• concatenation
  • similar files, loading with / Loading similar files with concatenation
• Configurations artifact / Understanding artifacts
• conformed dimensions
  • about / Denormalizing dimensions and conformed dimensions, Creating conformed dimensions
  • creating / Creating conformed dimensions
• Connect button
  • using / Using the Connect button
• Connections
  • configuring / Configuring connections
• Connections artifact / Understanding artifacts
• connection types
  • File / Configuring connections, Configuring a File connection
  • Database / Configuring connections, Connecting to a database
  • QVX Connector / Configuring connections
• Connect To statement / Understanding the Connect To statement
• contents
  • loading, of QVW / Loading the content of another QVW
• control chart
  • calculating, Aggr used / Using Aggr to calculate a control chart
• control structures
  • using / Using control structures
  • branching, with conditional statements / Branching with conditional statements
  • looping, in script / Looping in the script
  • exiting / Exiting
  • variables, using for error handling / Using variables for error handling
  • ScriptError / ScriptError
• Copy operator / Utility
• Cos() function / Generating fact table rows
• Crosstable wizard
  • using / Using the Crosstable wizard
• custom driver
  • about / Connecting to databases
• Customer extract
  • setting up, in Mockaroo / Generating dimension values

D

• dashboards
  • designing / Designing dashboards
• data
  • associating / Associating data
  • joining / Joining data
  • mapping, with ApplyMap / Mapping data with ApplyMap
  • obtaining / Getting data from anywhere
  • loading, from QlikView / Loading data from QlikView
  • optimal loading, from QVD / Optimal loading from QVD
  • viewing, from different directions / Looking at data from different directions
• data, loading
  • about / Loading data quickly
  • compression settings / Understanding compression settings
• Database connection
  • about / Configuring connections, Connecting to a database
• database connection
  • about / Connecting to databases
  • driver types / Connecting to databases
• data extraction, ETL approach
  • about / Extracting data
  • extractor folder structure, creating / Creating an extractor folder structure
  • script types, differentiating / Differentiating types of scripts
  • extractors, executing / Executing the extractors
• dataflow
  • creating / Creating the dataflow
  • packaging / Packaging the dataflow
• Dataflow artifact / Understanding artifacts
• dataflow toolbox
  • about / Understanding the dataflow toolbox
  • Inputs / Inputs
  • Outputs / Outputs
  • transformers operator / Transformers
  • Utility / Utility
• Data Interchange Format (DIF) / Delimited files
• data islands / Data islands
• data loading concepts
  • reviewing / Reviewing data loading concepts
  • data, obtaining / Getting data from anywhere
  • data, loading from QlikView / Loading data from QlikView
  • similar files, loading with concatenation / Loading similar files with concatenation
  • dissimilar files, loading with Concatenate / Loading dissimilar files with Concatenate and For Each
  • dissimilar files, loading with For Each / Loading dissimilar files with Concatenate and For Each
  • tables, storing to QVD / Storing tables to QVD
• data load steps, ETL approach
  • about / Loading data
  • UserApp folder structure, creating / Creating a UserApp folder structure
  • executing / Executing the load step
• Datascript Modules artifact / Understanding artifacts
• data storage, QlikView
  • about / Understanding how QlikView stores its data
  • great primer / A great primer
  • data tables / Looking at things from a simple level
  • memory statistics, exporting for document / Exporting the memory statistics for a document
• data transformation, ETL approach
  • about / Transforming data
  • transformer folder structure, creating / Creating a transformer and model folder structure
  • model folder structure, creating / Creating a transformer and model folder structure
  • transformers, executing / Executing transformers
• datatypes, QlikView
  • numeric / Getting data from anywhere
  • dual / Getting data from anywhere
• data visualization
  • history, reviewing / Reviewing the history of data visualization, Beginning the story
  • geometry, analyzing / Analyzing geometry
  • stories, telling with diagrams / Telling stories with diagrams
  • story up to date, bringing / Bringing the story up to date, Following the leaders
• DBMS
  • about / Associating data
• delimited files
  • about / Delimited files
• Deployment Packages artifact / Understanding artifacts
• descriptive metadata
  • about / Understanding what metadata is, Descriptive metadata
  • establishing / Establishing descriptive metadata
  • document-level information, adding / Adding document-level information
  • fields, naming / Naming and renaming fields
  • fields, renaming / Naming and renaming fields
  • fields, tagging / Tagging fields
  • Tag statement, used for tagging field / Using the Tag statement to tag a field
  • field comments, adding / Adding field comments
  • tables, renaming / Renaming and commenting on tables
  • commenting, on tables / Renaming and commenting on tables
  • commenting, in charts / Commenting in charts
  • qualified fields, renaming automatically / Automatically renaming qualified fields
• dimensional data modeling
  • about / Dimensional data modeling
• dimensional facts
  • creating / Creating dimensional facts
• dimensions
  • versus facts / Differentiating between facts and dimensions
  • denormalizing / Denormalizing dimensions and conformed dimensions
• dimension tables
  • designing / Designing dimension tables
• dimension values
  • generating / Generating dimension values
• Direct Discovery
  • using / Using Direct Discovery
  • restrictions / Direct Discovery restrictions
  • syntax / Direct Discovery syntax
  • example / Looking at an example Direct Query
• direct field comparison / Direct field comparison
• DirList function / DirList
• dissimilar files
  • loading, with Concatenate / Loading dissimilar files with Concatenate and For Each
  • loading, with For Each / Loading dissimilar files with Concatenate and For Each
• Do $$$ Loop statement
  • about / Do … Loop
• document
  • memory statistics, exporting for / Exporting the memory statistics for a document
• document-level information, descriptive metadata
  • adding / Adding document-level information
  • document, without additional metadata / Documents without any additional metadata
  • Document Properties window / Document Properties
  • Management Console / Management Console
• Document Analyzer
  • URL / Extracting metadata
• Document Analyzer tool
  • URL, for downloading / Reducing the number of columns
• document chaining
  • overview / Drilling across with document chaining
• document licenses
  • about / Data islands
• Document Properties window / Document Properties
• Dollar-sign Expansion
  • variables, using with / Using variables with Dollar-sign Expansion
  • about / Using variables with Dollar-sign Expansion, Understanding Dollar-sign Expansion
  • two-step process, following / Following the two-step process
  • parameters, using with / Using parameters with variables and Dollar-sign Expansion
  • variables, using in expressions / Using variables in expressions
  • used, with Set Analysis / Using Dollar-sign Expansion with Set Analysis
  • Concat, using with / Using Concat with Dollar-sign Expansion
• Dollar-sign expansion
  • applying, in script / Applying variables and the Dollar-sign Expansion in the script
• Dollar-sign expansions
  • nesting / Nesting Dollar-sign Expansions
• driver types, database connection
  • ODBC / Connecting to databases
  • OLEDB / Connecting to databases
  • custom / Connecting to databases
• dual / Cartesian joins
• duplicate key values effect
  • on joins / Understanding the effect of duplicate key values on joins

E

• E element function
  • using / Using the P and E element functions
• effective visualizations
  • designing / Designing effective visualizations
  • affordances / Understanding affordances
  • screen, designing of real estate / Grading your screen's real estate, Preference for the right
  • screen elements, positioning / Positioning screen elements
  • quantative thinking / Thinking quantitatively
  • dashboards, designing / Designing dashboards
  • charts, selecting / Choosing charts
  • color, using / Using color, Color should have meaning
  • maps, using / Using maps
• Enable Transformation Step option
  • about / Enabling a transformation step
  • Garbage tab / Garbage
  • Fill tab / Fill
  • Column feature / Column
  • Context tab / Context
  • Unwrap function / Unwrap
  • Rotate function / Rotate
• Enterprise Data Warehouse (EDW)
  • about / Dimensional data modeling
• ErrorMode variable
  • about / ErrorMode
  • values / ErrorMode
• ETL
  • Expressor, using for / Using QlikView Expressor for ETL
• ETL approach
  • advantages / Understanding why you should use an ETL approach
  • overall data loading, speeding up / Speeding up overall data loading
  • extracted data, reusing in multiple documents / Reusing extracted data in multiple documents
  • common business rules, applying across multiple documents / Applying common business rules across multiple documents
  • conformed dimensions, creating / Creating conformed dimensions
  • self-service data layer, provisioning / Provisioning a self-service data layer
  • used, for creating QVD data layers / Using an ETL approach to create QVD data layers
  • Expressor, using for / Understanding why to use Expressor for ETL
• ETL approach, QVD data layers
  • StoreAndDrop subroutine, creating / Creating a StoreAndDrop subroutine
  • data, extracting / Extracting data
  • data, transforming / Transforming data
  • data, loading / Loading data
• example execution
  • running / Running an example execution
• Exists clause
  • used, for loading QVD / Using an Exists clause
• expressions
  • variables, using in / Using variables in expressions
• Expressor
  • using, for ETL / Using QlikView Expressor for ETL, Understanding why to use Expressor for ETL
  • components / Introducing Expressor
  • benefits / Understanding why to use Expressor for ETL
• extensions
  • managing / Managing extensions
• External Files artifact / Understanding artifacts
• extractor folder structure
  • Includes subfolder / Creating an extractor folder structure
  • QScript subfolder / Creating an extractor folder structure
  • QVD subfolder / Creating an extractor folder structure

F

• factless fact tables
  • about / Factless fact tables
• facts
  • versus dimensions / Differentiating between facts and dimensions
  • summing with / Summing with facts
  • additive / Summing with facts
  • semi-additive / Summing with facts
  • non-additive / Summing with facts
• Fact table rows
  • generating / Generating fact table rows
• fact tables
  • about / Discovering more about facts
  • transaction fact tables / Transaction fact tables
  • periodic snapshot fact tables / Periodic snapshot fact tables
  • factless fact tables / Factless fact tables
  • dealing, with nulls / Dealing with nulls in fact tables in QlikView
  • joining / Joining the fact tables together
  • concatenating / Concatenating fact tables
  • grain, modifying of / Changing the grain of a fact table
  • linking, of different grains / Linking fact tables of different grains
• Fertile Crescent
  • URL / Counting numbers
• field comments, descriptive metadata
  • adding / Adding field comments
• Field Data button / Using Table Files Wizard
• field renaming considerations, descriptive metadata
  • dimensions / Dimensions
  • key fields / Key fields
  • measures / Measures
• fields
  • comparing, between states / Comparing fields between states
  • preloading, into QVDs / Preloading fields into QVDs
• fields, descriptive metadata
  • naming / Naming and renaming fields
  • renaming / Naming and renaming fields
  • guidelines, for renaming / Guidelines to rename fields
  • renaming, As used / Renaming fields using As
  • Qualify, using / Using Qualify
  • renaming, Rename used / Renaming fields using Rename
  • renaming, mapping table used / Using a mapping table to rename fields
  • tagging / Tagging fields
  • tagging, Tag statement used / Using the Tag statement to tag a field
  • tagging, mapping table used / Tagging fields using a mapping table
  • hiding / Hiding fields
  • hiding, automatically based on prefix or suffix / Hiding fields automatically based on prefix or suffix
  • hiding, tagging used / Using tagging to hide fields
• fields, Set Analysis
  • direct field comparison / Direct field comparison
  • Concat, used with Dollar-sign Expansion / Using Concat with Dollar-sign Expansion
  • P element function, using / Using the P and E element functions
  • E element function, using / Using the P and E element functions
• FieldValueCount function / FieldValueCount
• File connection
  • about / Configuring connections
  • configuring / Configuring a File connection
• FileList function / FileList
• files
  • loading, relative paths used / Using relative paths
• Filter operator / Utility
• First function / Using inter-record and range functions
• FirstSortedValue function
  • Distinct parameter / Taking the most recently changed record using FirstSortedValue
  • Territory parameter / Taking the most recently changed record using FirstSortedValue
  • -From parameter / Taking the most recently changed record using FirstSortedValue
  • 1 parameter / Taking the most recently changed record using FirstSortedValue
  / FirstSortedValue
• First statement / First
• fixed width files
  • about / Fixed width files
• flag arithmetic / Flag arithmetic
• Floor() function
  • about / Holding dates
• Floor function / Getting data from anywhere
• For $$$ Next loops
  • about / For … Next loops
• Force 32 Bit option / Explaining the Force 32 Bit option
• For Each
  • dissimilar files, loading with / Loading dissimilar files with Concatenate and For Each
• For Each $$$ Next loops
  • about / For Each … Next loops
  • FileList function / FileList
  • DirList function / DirList
• French discord
  • about / French discord
• from/to dates
  • managing, hash used / Using hash to manage from/to dates
• functions, for counting records
  • RecNo() / RecNo
  • RowNo() / RowNo
  • FieldValueCount / FieldValueCount
  • NoOfRows / NoOfRows
  • NoOfColumns / NoOfColumns
• Funnel operator / Utility
• fuzzy search / Fuzzy search

G

• geometry, analyzing
  • Grecian influences / Grecian influences
  • French discord / French discord
• grain
  • about / Understanding the grain
  • modifying, of fact table / Changing the grain of a fact table
• grains
  • fact tables, linking of / Linking fact tables of different grains
• Grecian influences
  • about / Grecian influences
• Gutenberg diagram
  • about / The Gutenberg diagram

H

• hash
  • used, for managing from/to dates / Using hash to manage from/to dates
• Hash function
  • used, for creating composite keys / Using one of the Hash functions
• HierarchyBelongsTo function
  • parent associations, creating with / Creating parent associations with HierarchyBelongsTo
  • NodeID parameter / Creating parent associations with HierarchyBelongsTo
  • ParentID parameter / Creating parent associations with HierarchyBelongsTo
  • NodeName parameter / Creating parent associations with HierarchyBelongsTo
  • AncestorID parameter / Creating parent associations with HierarchyBelongsTo
  • AncestorName parameter / Creating parent associations with HierarchyBelongsTo
  • DepthDiff parameter / Creating parent associations with HierarchyBelongsTo
• Hierarchy function
  • leaves, creating with / Creating leaves with Hierarchy
  • NodeID parameter / Creating leaves with Hierarchy
  • ParentID parameter / Creating leaves with Hierarchy
  • NodeName parameter / Creating leaves with Hierarchy
  • ParentName parameter / Creating leaves with Hierarchy
  • PathSource parameter / Creating leaves with Hierarchy
  • PathName parameter / Creating leaves with Hierarchy
  • PathDelimiter parameter / Creating leaves with Hierarchy
  • Depth parameter / Creating leaves with Hierarchy
• HTML files
  • about / HTML files

I

• identifiers
  • identifying / Identifying the identifiers
  • 1 / Identifying the identifiers
  • $ / Identifying the identifiers
  • $n / Identifying the identifiers
  • $_n / Identifying the identifiers
  • Bookmark (ID or name) / Identifying the identifiers
  • State name / Identifying the identifiers
  • Alternate States, using as / Using Alternate States as identifiers
• If $$$ Then $$$ ElseIf construct / If … Then … ElseIf
• incremental data load
  • about / Loading data incrementally
  • script, establishing for basic process / Establishing the script for the basic process
  • running, on data addition / Running an incremental load when data is only added
  • running, on data modification / Loading incrementally when data might be modified
  • deletions, handling from source system / Handling deletions from the source system
  • situations, handling / Handling situations where there is no modify date
• Infographics
  • creating / Creating infographics
• ink-to-data ratio
  • about / The ink-to-data ratio
• inner join
  • about / Inner joins
• Inputs toolbox, dataflow
  • Read File operator / Inputs
  • Read Table operator / Inputs
  • SQL Query operator / Inputs
  • Read Custom operator / Inputs
  • Read Lookup Table operator / Inputs
  • Read Excel operator / Inputs
  • Read QlikView operator / Inputs
  • Read QVX Connector operator / Inputs
• installation, jMeter / Installing JMeter
• installation, scalability tools / Installing the scalability tools
• inter-record function
  • using / Using inter-record and range functions
• IntervalMatch function
  • using, with SCDs / Using IntervalMatch with SCDs

J

• jMeter
  • about / Testing scalability with JMeter
  • scalability, testing with / Testing scalability with JMeter
  • URL, for obtaining from Apache website / Installing JMeter
  • URL, for older version / Installing JMeter
  • URL, for latest version of Java runtime / Installing JMeter
  • installing / Installing JMeter
• Join
  • about / Understanding Join and Keep
  • versus Concatenate / Differentiating Concatenate and Join
• join model
  • about / Associating data
• Join operator / Transformers
• joins
  • inner join / Inner joins
  • left join / Left and right joins
  • right join / Left and right joins
  • outer join / Outer joins
  • Cartesian join / Cartesian joins

K

• Keep
  • about / Understanding Join and Keep, Understanding Keep
• key collision
  • URL / Using one of the Hash functions
• Kimball dimensional modeling
  • about / Dimensional data modeling
• Kimball four-step dimensional design process
  • defining / Defining Kimball's four-step dimensional design process
  • business process, selecting / Selecting the business process
  • grain, declaring / Declaring the grain
  • dimensions, identifying / Identifying the dimensions
  • facts, identifying / Identifying the facts
• Kimball Group
  • online resources / Dimensional data modeling

L

• Last function / Using inter-record and range functions
• late arriving dimension values
  • dealing with / Dealing with missing or late arriving dimension values
• leaves
  • creating, with Hierarchy function / Creating leaves with Hierarchy
• left join
  • about / Left and right joins
• LET
  • versus SET / SET versus LET
• LET keyword
  • about / SET versus LET
• Let statement / Applying variables and the Dollar-sign Expansion in the script
• libraries
  • working with / Working with libraries and projects
• loading techniques
  • mastering / Mastering loading techniques
  • data, loading incrementally / Loading data incrementally
  • data model, reloading partially / Partially reloading only one part of the data model
  • contents, loading of QVW / Loading the content of another QVW
• Lookup Tables artifact / Understanding artifacts
• looping, in script
  • about / Looping in the script
  • AutoGenerate / AutoGenerate
  • For $$$ Next loops / For … Next loops
  • For Each $$$ Next loops / For Each … Next loops
  • Do $$$ Loop / Do … Loop
• Lua
  • URL / Introducing Expressor

M

• mapping table
  • used, for renaming fields / Using a mapping table to rename fields
  • used, for tagging field / Tagging fields using a mapping table
• maps
  • using / Using maps
• Massive Open Online Course (MOOC) / Alberto Cairo
• memory statistics
  • exporting, for document / Exporting the memory statistics for a document
• meta
  • about / Understanding what metadata is
• metadata
  • about / Understanding what metadata is
  • structural / Understanding what metadata is, Structural metadata
  • descriptive / Understanding what metadata is, Descriptive metadata
  • administrative / Understanding what metadata is, Administrative metadata
  • extracting / Extracting metadata
  • structure, exploring / Exporting the structure
  • extracting, from QVD / Extracting from QVD files
  • extracting, from QVW / Extracting from QVW files
• metadata intelligence / Using QlikView Expressor for ETL
• missing dimension values
  • dealing with / Dealing with missing or late arriving dimension values
• Mockaroo
  • URL / Generating dimension values
  • Customer extract, setting up / Generating dimension values
• modifiers
  • defining, as sets / Understanding that modifiers are sets
• More Or Less
  • URL / Thinking quantitatively
• Multi-Transform operator / Transformers
• multiple fact tables
  • dealing with / Dealing with multiple fact tables in one model
• multiple listboxes search / Searching in multiple listboxes
• multiple values search / Multiple values search

N

• NoConcatenate keyword / Reviewing Concatenate
• nodistinct option
  • avoiding / No to nodistinct
• non-additive facts
  • about / Summing with facts
• NoOfColumns function / Using inter-record and range functions, NoOfColumns
• NoOfRows function / Using inter-record and range functions, NoOfRows
• normal search
  • about / Normal search
  • example searches / Normal search
• Now() function
  • about / Holding dates
  • parameters / Holding dates
• Num() function
  • about / Holding dates
• numbers
  • mapping / Mapping numbers
• numeric fields search
  • about / Searching numeric fields
  • numeric search option / Numeric search
• numeric search option
  • about / Numeric search
  • example combinations / Numeric search
  / Numeric search

O

• ODBC
  • about / Connecting to databases
• OLEDB
  • about / Connecting to databases
• Operational Information QlikView Governance Dashboard
  • reviewing / Reviewing operational information
• Operator Templates artifact / Understanding artifacts
• options, QlikView Governance Dashboard
  • configuring / Configuring the Dashboard options
  • User Configuration Script? / Configuring the Dashboard options
  • Multi-cluster Reload? / Configuring the Dashboard options
  • Profile / Configuring the Dashboard options
  • Documents / Configuring the Dashboard options
  • Operational Logs / Configuring the Dashboard options
  • Repository Path / Configuring the Dashboard options
• outer join
  • about / Outer joins
• Outputs toolbox, dataflow
  • about / Outputs
  • Write File operator / Outputs
  • Write Table operator / Outputs
  • Write Teradata PT operator / Outputs
  • Write Custom operator / Outputs
  • Write Lookup Table operator / Outputs
  • Write Parameters operator / Outputs
  • Trash operator / Outputs
  • Write Excel operator / Outputs
  • Write QlikView operator / Outputs

P

• parameters
  • used, with variables / Using parameters with variables and Dollar-sign Expansion
  • used, with Dollar-sign Expansion / Using parameters with variables and Dollar-sign Expansion
  • passing, to variables / Passing parameters to variables – macro functions
• parameters, Peek function
  • Field name / Peek
  • Row index / Peek
  • Table name / Peek
• parent associations
  • creating, with HierarchyBelongsTo function / Creating parent associations with HierarchyBelongsTo
• partial reloading
  • about / Partially reloading only one part of the data model
  • table, replacing / Replacing a table
  • new rows, adding to table / Adding new rows to a table
  • script execution, managing / Managing script execution in partial reloads
• Peek function
  • about / Peek
  • parameters / Peek
• P element function
  • using / Using the P and E element functions
• periodic snapshot fact tables
  • about / Periodic snapshot fact tables
• picture superiority / Understanding picture superiority
• Pie-Gauge
  • about / Low cardinality, part-to-whole comparison
• Pivot Column operator / Transformers
• Pivot Row operator / Transformers
• Previous function / Previous
• profiles, QlikView Governance Dashboard
  • managing / Managing profiles
• projects
  • working with / Working with libraries and projects
• properties, Read File operator
  • Name / Configuring a Read File operator
  • Connection / Configuring a Read File operator
  • Schema / Configuring a Read File operator
  • Type / Configuring a Read File operator
  • Mapping / Configuring a Read File operator
  • File name / Configuring a Read File operator
  • Quotes / Configuring a Read File operator
  • Skip rows / Configuring a Read File operator
  • Error handling / Configuring a Read File operator
  • Show errors / Configuring a Read File operator

Q

• Qlik Community
  • URL / Using Direct Discovery, Obtaining the scalability tools
• Qlik community
  • URL / Understanding synthetic keys, Creating a calendar dimension
• Qlik Design Blog
  • URL / Generating fact table rows, A great primer
• QlikView
  • URL / Generating dimension values
  • data storage / Understanding how QlikView stores its data
  • URL, for web design blog / Optimizing performance by creating counter fields
  • about / Getting data from anywhere
  • data, loading from / Loading data from QlikView
  • variables, using / Using variables in QlikView
  • reference link, for books / Reusing code
• QlikView cache
  • URL / Analyzing application information
• QlikView calculation engine
  • about / The QlikView calculation engine
  • flags, creating for well-known conditions / Creating flags for well-known conditions
  • chart, sorting for well-known conditions / Sorting for well-known conditions
• QlikView Components library
  • URL / Reusing code
• QlikView File button / Using Table Files Wizard
• QlikView Governance Dashboard
  • about / Deploying the QlikView Governance Dashboard
  • deploying / Deploying the QlikView Governance Dashboard
  • profiles, managing / Managing profiles
  • options, configuring / Configuring the Dashboard options
  • Operational Information, reviewing / Reviewing operational information
  • application information, analyzing / Analyzing application information
• QlikView Server cache
  • URL / Loading the content of another QVW
• qualified fields, descriptive metadata
  • renaming, automatically / Automatically renaming qualified fields
• Qualify
  • using / Using Qualify
• Qualify statement
  • about / Data islands
• QVD
  • XML header / Understanding QlikView Data files
  • symbol tables / Understanding QlikView Data files
  • bit-stuffed data table / Understanding QlikView Data files
  • tables, storing to / Storing tables to QVD
  • metadata, extracting from / Extracting from QVD files
  • loading, Exists clause used / Using an Exists clause
  • fields, preloading into / Preloading fields into QVDs
• QVD/QVX files
  • about / QVD/QVX files
• QVD data layers
  • creating, ETL approach used / Using an ETL approach to create QVD data layers
• QVD files
  • about / Understanding QlikView Data files
  • using / Using QVD files
• QVW
  • contents, loading of / Loading the content of another QVW
  • metadata, extracting from / Extracting from QVW files
• QVX Connector connection
  • about / Configuring connections
  • creating / Creating a QVX Connector Connection
• QVX output
  • creating / Creating a QVX output

R

• RAG system
  • about / What does RAG mean?
• Rand() function / Generating fact table rows
• range function
  • using / Using inter-record and range functions
• Read Custom operator / Inputs
• Read Excel operator / Inputs
• Read File operator / Inputs
  • configuring / Configuring a Read File operator
  • properties / Configuring a Read File operator
• Read Lookup Table operator / Inputs
• Read QlikView operator / Inputs
• Read QVX Connector operator / Inputs
• Read Table operator / Inputs
• RecNo() function / RecNo
• records
  • counting / Counting records
• relative paths
  • used, for loading files / Using relative paths
• Rename
  • used, for renaming fields / Renaming fields using Rename
• repository workspace / Creating a workspace
• reusable dimension methods
  • about / Learning some useful reusable dimension methods
  • calendar dimension, creating / Creating a calendar dimension
  • hierarchies, unwrapping / Unwrapping hierarchies
  • parent associations, creating with HierarchyBelongsTo function / Creating parent associations with HierarchyBelongsTo
• right join
  • about / Left and right joins
• RowNo() function / RowNo
• RowNo function / Using inter-record and range functions
• rows
  • concatenating / Concatenating rows
• rules, for dealing with humans
  • patterns, matching / Matching patterns
  • numbers, counting / Counting numbers
  • numbers, estimating / Estimating numbers
  • picture superiority / Understanding picture superiority
  • conclusions, drawing / Drawing conclusions

S

• scalability
  • testing, with jMeter / Testing scalability with JMeter
• scalability tools
  • obtaining / Obtaining the scalability tools
  • installing / Installing the scalability tools
  • script generator / About the scalability tools
  • script executor / About the scalability tools
  • analyzer / About the scalability tools
• SCDs
  • handling / Handling slowly changing dimensions
  • URL / Handling slowly changing dimensions
  • FirstSortedValue, used for taking most recently changed record / Taking the most recently changed record using FirstSortedValue
  • IntervalMatch function, using with / Using IntervalMatch with SCDs
  • hash, used for managing from/to dates / Using hash to manage from/to dates
• schema
  • configuring / Configuring a schema
• Schemas artifact / Understanding artifacts
• screen elements, positioning
  • about / Positioning screen elements
  • charts, on left / Charts on the left
  • listboxes, on right / Listboxes on the right
  • dates, on top / Dates on top
  • layout grid, using / Using the layout grid
• script
  • variables, applying in / Applying variables and the Dollar-sign Expansion in the script
  • Dollar-sign expansion, applying in / Applying variables and the Dollar-sign Expansion in the script
  • exiting / Exiting the script
• script, types
  • low frequency / Differentiating types of scripts
  • simple, high frequency / Differentiating types of scripts
  • complex, high frequency / Differentiating types of scripts
• script constructs
  • exiting / Exiting other constructs
• script debugger
  • two-step process, following in / Following the steps in the script debugger
• ScriptErrorCount variable / ScriptErrorCount and ScriptErrorList
• ScriptErrorList variable / ScriptErrorCount and ScriptErrorList
• ScriptError variable / ScriptError
• searches
  • used, in Set Analysis / Using searches in Set Analysis
• searching, in QlikView
  • about / Searching in QlikView
  • text-based search / Searching for text
  • wildcard search / Wildcard search
  • numeric fields search / Searching numeric fields
  • automatic interpretation, of searches / Automatic interpretation of searches
  • multiple values search / Multiple values search
  • multiple listboxes search / Searching in multiple listboxes
• Select wizard
  • about / The Select wizard
• self-service data layer
  • provisioning / Provisioning a self-service data layer
• semi-additive facts
  • about / Summing with facts
• SET
  • versus LET / SET versus LET
• set
  • about / Explaining what we mean by a set
  • Set identifiers / Set identifiers
  • Set modifiers / Set modifiers
• Set Analysis / Optimizing performance by creating counter fields, Set Analysis
  • using / Using advanced Set Analysis
  • identifiers, identifying / Identifying the identifiers
  • modifiers, defining as sets / Understanding that modifiers are sets
  • Set arithmetic / Set arithmetic
  • searches, using / Using searches in Set Analysis
  • Dollar-sign Expansion, using with / Using Dollar-sign Expansion with Set Analysis
  • other fields, comparing / Comparing to other fields
  • with Alternate States / Set Analysis with Alternate States
• Set Analysis, with Alternate States
  • Alternate States, used as identifiers / Using Alternate States as identifiers
  • fields, comparing between states / Comparing fields between states
• Set arithmetic operators
  • about / Set arithmetic
  • + (Union) / Set arithmetic
  • - (Exclusion) / Set arithmetic
  • * (Intersection) / Set arithmetic
  • / (Symmetric difference) / Set arithmetic
• Set identifiers
  • about / Set identifiers
  • {1} / Set identifiers
  • {$} / Set identifiers
• SET keyword
  • about / SET versus LET
• Set modifiers / Set modifiers
• Set statement / Applying variables and the Dollar-sign Expansion in the script
• SFW question
  • about / Understanding the SFW question
• similar files
  • loading, with concatenation / Loading similar files with concatenation
• Sin() function / Generating fact table rows
• snowflake schema / Understanding star schemas
• Sort operator / Utility
• SQL Query operator / Inputs
• standalone workspace / Creating a workspace
• star schemas
  • about / Understanding star schemas
• states
  • fields, comparing between / Comparing fields between states
• state space / The QlikView calculation engine
• StoreAndDrop subroutine
  • creating / Creating a StoreAndDrop subroutine
• stories, with diagrams
  • charts / Educating with charts
  • charts, inventing / Inventing new charts
  • Infograph, creating / Creating infographics
  • data visualization, using / Using data visualization to persuade, Enrico Bertini and Stefaner Moritz
• strategies, for reducing data size / performance improvement
  • about / Strategies to reduce the data size and improve performance
  • field values, optimizing / Optimizing field values and keys
  • keys, optimizing / Optimizing field values and keys
  • data, optimizing by removing keys / Optimizing data by removing keys using ApplyMap
  • performance optimization, by removing keys / Optimizing performance by removing keys by joining tables
  • memory, optimizing by removing low cardinality fields / Optimizing memory by removing low cardinality fields
• string concatenation
  • used, for creating composite keys / Using string concatenation
• structural metadata
  • about / Understanding what metadata is, Structural metadata
• subroutines
  • about / Subroutines
  • example / Subroutines
• Sum function
  • about / Summing with facts
• Sum of If / Sum of If
• surrogate keys
  • about / Understanding surrogate keys
• Switch $$$ Case construct / Switch … Case
• synthetic key
  • about / Understanding synthetic keys
  • example / Understanding synthetic keys
  • benefits / Understanding synthetic keys

T

• Table Files button / Using Table Files Wizard
• Table Files Wizard
  • using / Using Table Files Wizard
  • relative paths, used for loading file / Using relative paths
  • delimited files / Delimited files
  • fixed width files / Fixed width files
  • XML files / XML files
  • HTML files / HTML files
  • QVD/QVX files / QVD/QVX files
• tables
  • associating, automatically / Automatically associating tables
  • storing, to QVD / Storing tables to QVD
• tables, descriptive metadata
  • renaming / Renaming and commenting on tables
  • commenting on / Renaming and commenting on tables
• tagging
  • used, for hiding fields / Using tagging to hide fields
• Tag statement
  • used, for tagging field / Using the Tag statement to tag a field
• test data
  • generating / Generating test data
  • dimension values, generating / Generating dimension values
  • Fact table rows, generating / Generating fact table rows
• text-based search
  • about / Searching for text
  • normal / Searching for text
  • wildcard / Searching for text
• The Data Warehouse Toolkit
  • URL / Creating conformed dimensions
• TimeStamp() function
  • about / Holding dates
• Today() function
  • about / Holding dates
  • parameters / Holding dates
• Top function / Using inter-record and range functions
• Total qualifier
  • applying / Applying the Total qualifier
• Trace statement / Following the steps in the script debugger
• transaction fact table
  • about / Transaction fact tables
• Transformation operation
  • configuring / Adding a Transformation operation
• transformer operator, dataflow
  • Aggregate / Transformers
  • Join / Transformers
  • Transform / Transformers
  • Multi-Transform / Transformers
  • Pivot Row / Transformers
  • Pivot Column / Transformers
• Transform operator / Transformers
• Trash operator / Outputs
• two-step process
  • following / Following the two-step process
  • following, in script debugger / Following the steps in the script debugger
  • following, in chart expression / Following the steps in a chart expression, Understanding when the steps happen in chart expressions
• types
  • configuring / Configuring types and schemas
  • Atomic type / Adding additional Atomic types
  • Composite type / Creating Composite types
• Types artifact / Understanding artifacts

U

• Unique operator / Utility
• Unless statement
  • about / When and Unless
• Untag statement / Using the Tag statement to tag a field
• use cases, variables
  • dates, holding / Holding dates
  • paths, holding / Holding paths
• utility operators, dataflow
  • about / Utility
  • Buffer / Utility
  • Copy / Utility
  • Filter / Utility
  • Sort / Utility
  • Funnel / Utility
  • Unique / Utility

V

• variables
  • used, for calculations / Calculations using variables
  • parameters, using with / Using parameters with variables and Dollar-sign Expansion
  • used, in expressions / Using variables in expressions
  • applying, in script / Applying variables and the Dollar-sign Expansion in the script
  • use cases / Examining common usage, Holding dates
  • parameters, passing to / Passing parameters to variables – macro functions
• variables, in QlikView
  • about / Using variables in QlikView
  • SET versus LET / SET versus LET
  • used, for holding common expressions / Using variables to hold common expressions
  • used, with Dollar-sign Expansion / Using variables with Dollar-sign Expansion
• variable values
  • examining, during reloads / Examining variable values during reloads
• vertical calculation
  • inter-record function, using / Using inter-record and range functions
  • range function, using / Using inter-record and range functions
  • Total qualifier, applying / Applying the Total qualifier
  • advanced aggregations, creating with Aggr / Creating advanced aggregations with Aggr
• vertically
  • calculating / Calculating vertically

W

• Web Files button / Using Table Files Wizard
• When statement
  • about / When and Unless
• wildcard search
  • about / Wildcard search
  • characters / Wildcard search
  • example searches / Wildcard search
  • normal search / Normal search
  • fuzzy search / Fuzzy search
  • associative search / Associative search
  • advanced search / Advanced search
• workspace
  • about / Creating a workspace
  • standalone workspace / Creating a workspace
  • repository workspace / Creating a workspace
  • creating / Creating a workspace
• Write Custom operator / Outputs
• Write Excel operator / Outputs
• Write File operator / Outputs
• Write Lookup Table operator / Outputs
• Write Parameters operator / Outputs
• Write QlikView operator / Outputs
• Write Table operator / Outputs
• Write Teradata PT operator / Outputs

X

• XML files
  • about / XML files