Index
A
- Above function / Using inter-record and range functions
- Access Document Properties (Users), user privilege / Document-level security
- ACCESS field / Section access fields
- Access Restriction Table Wizard dialog / Section access fields, Omitting fields
- Access Sheet Object Properties, user privilege / Sheet-level security
- Access Sheet Properties (Users), user privilege / Sheet-level security
- Access Tab row Properties, user privilege / Document-level security
- Accumulation option
- about / Expressions
- actions
- adding, to text object / Adding actions to a Text object
- additive facts
- about / Summing with facts
- Add new tab button / Applying IntervalMatch to the Carrier Decode table
- Add Sheet Objects, user privilege / Sheet-level security
- Add Sheets, user privilege / Document-level security
- Admin Override Security, user privilege / Document-level security
- 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 Color Map dialog window / Setting the default color map
- 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
- 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
- aggregation functions
- sum() function / Aggregation functions
- Min() function / Aggregation functions
- Max() function / Aggregation functions
- Only() function / Aggregation functions
- MinString() function / Aggregation functions
- MaxString() function / Aggregation functions
- Concat() function / Aggregation functions
- Count() function / Aggregation functions
- Aggr function / Creating advanced aggregations with Aggr
- agile development
- about / Agile development
- user story / User story
- minimum viable product (MVP) / Minimum Viable Product
- Airline Operations
- DAR principle, adding to / Applying the DAR principle to Airline Operations
- document requisites / Document requirements, Creating the new Dashboard sheet
- Air Time % gauge
- creating / Adding Air Time %
- AlchemyAPI
- URL / Social media analysis
- alignment option / The Presentation tab
- Allow Copy/Clone option / The Layout tab
- Allow Export, user privilege / Document-level security
- Allow Maximize option / The Caption tab
- Allow Minimize option / The Caption tab
- Allow Move/Size option / The Layout tab
- Allow Print (When Export Is Prohibited), user privilege / Document-level security
- Allow User Reload, user privilege / Document-level security
- Alternate States
- used, as identifiers / Using Alternate States as identifiers
- Always One Selected Value checkbox / The General tab
- analysis sheet
- about / Creating the Analysis sheet
- creating / Creating the Analysis sheet
- chart, adding to / Adding a new chart
- bar chart, adding to / Bar Chart
- line chart, adding to / Line Chart
- combo chart, adding to / Combo Chart
- scatter chart, adding to / Scatter Chart
- buttons, adding to / Button
- statistics box, adding to / Statistics box
- analysts
- about / User types, Analysts
- 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
- Apply Theme option / The Layout tab
- Apply To... option / The Layout tab
- Apply to All Sheets checkbox / Sheet-level security
- Apriori
- 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
- AsOfCalendar / AsOfCalendar
- associative model
- about / Associating data
- associative search / Associative search
- Atlassian Confluence
- URL / Local knowledge base
- Atomic type
- creating / Adding additional Atomic types
- AutoGenerate
- about / AutoGenerate
- AutoGenerate() function / Generating fact table rows
- automatic interpretation, of searches
- Auto Minimize option / The Caption tab, Auto minimize
- AutoNumber function
- used, for creating composite keys / Using the AutoNumber function
- AutoNumber script function / Understanding synthetic keys
- Available Fields listbox / The Sheet Properties dialog
- Average Inventory Value / Working capital breakdown
B
- Background Color option / Changing the caption colors
- background property / The Sheet Properties dialog
- Balanced Scorecard (BSC) Method
- about / The Balanced Scorecard method
- financial perspective / The financial perspective
- customer perspective / The customer perspective
- Business process perspective / The internal business process perspective
- internal perspective / The internal business process perspective
- learning perspective / The learning and growth perspective
- growth perspective / The learning and growth perspective
- consolidated data model / The Balanced Scorecard consolidated data model
- Balanced Scorecard (BSC) Method, dashboard design
- about / The Balanced Scorecard information dashboard design
- Gestalt principles of perceptual organization / The Gestalt principles of perceptual organization
- balance sheet / Balance sheet, Exercise 13.4, Exercise 13.5
- bar chart
- adding, to analysis sheet / Bar Chart
- options / Additional bar chart properties, Presentation
- versus line chart / Line Chart
- 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
- Binary load / Cloning a QlikView data model
- Block Chart
- about / Block Chart
- Bookmark Object
- adding / Adding a Bookmark Object
- 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
- border width option / The Layout tab
- 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
- BugHerd
- URL / Reporting issues
- BugHerd QlikView document extension
- URL / Reporting issues
- bullet graph
- about / Bullet graph, Exercise 18.1, Exercise 18.2
- URL / Bullet graph
- Business Intelligence (BI) / Data exploration, visualization, and discovery
- business process
- about / Selecting the business process
- buttons
- adding, to analysis sheet / Button
C
- 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
- capital breakdown
- working / Working capital breakdown, Exercise 15.5
- capital data model
- working / Working capital data model
- Caption Alignment option / The Caption tab
- Caption and Border Properties dialog window / Propagating the object appearance
- Carrier Decode table / The Carrier Decode table
- IntervalMatch, applying / Applying IntervalMatch to the Carrier Decode table
- Carrier Group ID field / Applying IntervalMatch to the Carrier Decode table
- Cartesian join
- about / Cartesian joins
- example / Cartesian joins
- cash flow statement / Cash flow statement, Exercise 13.6
- census data
- URL / Marketing data model
- chart
- adding, to analysis sheet / Adding a new chart
- chart calculation times
- optimizing / Optimizing chart calculation times
- chart colors
- defining / Defining chart colors
- chart components
- resizing / Gauges
- 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
- Chart Properties dialog
- about / Additional line chart properties
- Expressions tab / Expressions
- Style tab / Style
- Presentation tab / Presentation
- charts
- inserting, in container object / Container
- Chi-squared test of independence / Exercise 16.5
- circular gauge option / Not all expressions are numbers
- classic star schema / Understanding star schemas
- Clone option / Cloning the object for re-use
- code
- reusing / Reusing code
- Color Area and Color dialog windows / The Color Area and Color dialog windows
- ColumnNo function / Using inter-record and range functions
- combo chart
- about / Combo Chart
- adding, to analysis sheet / Combo Chart
- 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
- Concat() function / Aggregation functions
- 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
- 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
- container object
- 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/Clone Sheet Objects, user privilege / Sheet-level security
- Copy operator / Utility
- Count() function / Aggregation functions
- cross-selling
- visualization extension examples / Visualization extension examples for cross-selling
- Crosstable wizard
- using / Using the Crosstable wizard
- CSS
- tutorials, URL / Plan to master Qlik Sense data visualization
- Current Selections Box
- about / The Current Selections Box
- selections, making from / Making selections from the Current Selections Box
- custom driver
- about / Connecting to databases
- Customer extract
- setting up, in Mockaroo / Generating dimension values
- Customer Fact sheet
- data model, consolidated / Customer fact sheet consolidated data model
- Agile design / Customer Fact sheet Agile design
- in QlikView / Customer Fact sheet n QlikView
- Customer Fact sheet, advanced components
- about / Customer Fact sheet advanced components
- bullet graph / Bullet graph, Exercise 18.1, Exercise 18.2
- sparklines / Sparklines, Exercise 18.3
- Customer Fact sheet, Agile design
- about / Customer Fact sheet Agile design
- user stories, creating / Creating user stories
- user story, flow / User story flow
- user stories, converting into visualizations / Converting user stories into visualizations
- first visualization / Going beyond the first visualization
- customer profiling
- about / Customer profiling
- parallel coordinates / Parallel coordinates, Exercise 14.1, Exercise 14.2
- Sankey / Sankey, Exercise 14.3, Exercise 14.4
- market size analysis / Market size analysis, Exercise 14.6
- social media analysis / Social media analysis, Exercise 14.8, Exercise 14.10
- sales opportunity analysis / Sales opportunity analysis, Exercise 14.11
- customer stratification
- by distribution / Stratification by distribution, Exercise 15.8, Exercise 15.9
- visualizing / Visualizing stratification, Exercise 15.10
- cyclic groups
- about / Cyclic and Drill-down groups
- creating / Cyclic and Drill-down groups
D
- DAR principle
- adding, to Airline Operations / Applying the DAR principle to Airline Operations
- Dashboards
- about / User types
- dashboard sheet
- about / Creating the new Dashboard sheet
- setting up / Creating the new Dashboard sheet
- linked objects, adding / Linked Objects
- gauge charts, adding / Gauges
- pie charts, adding to / Adding a Pie chart
- dashboard sheets
- metrics, adding to / Adding a Text object
- dashboard users
- about / Dashboard users
- 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
- aggregating / Aggregating data
- flight data table, aggregating / Aggregating the Flight Data table
- transformation output / The Transformation output
- data, loading
- about / Loading data quickly
- compression settings / Understanding compression settings
- data architecture
- about / Data architecture
- two-stage architecture / Two-stage architecture
- environment, setting up / Setting up our environment
- Database connection
- database connection
- about / Connecting to databases
- driver types / Connecting to databases
- data exploration
- 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
- data model
- marketing / Marketing data model
- about / Operations data model
- data model, financial perspective
- about / Financial perspective data model, Exercise 13.1
- financial report metadata / Financial report metadata
- AsOfCalendar / AsOfCalendar
- income statement / Income statement, Exercise 13.2
- custom format cell / Custom format cell, Exercise 13.3
- balance sheet / Balance sheet, Exercise 13.4, Exercise 13.5
- cash flow statement / Cash flow statement, Exercise 13.6
- data model, sales perspective
- about / Sales perspective data model, Exercise 12.1
- null values / Data quality issues
- dimension value, missing / Missing dimension values
- fact value, missing / Missing fact values
- data, cleansing / Data formatting and standardization
- standardization / Data formatting and standardization
- case / Case
- unwanted characters / Unwanted characters
- dates and time / Dates and time
- master calendar / Master calendar, Customer stratification.
- pareto analysis / Pareto analysis
- exercise / Exercise 12.2, Exercise 12.3
- customer churn / Customer churn, Exercise 12.4
- data model issues, QlikView
- about / Common QlikView data model issues
- expression values, similarity / All expression values are exactly the same
- expression total / The expression total is not equal to the sum of the rows
- list box, duplicate values / Duplicate values in a list box
- data, requirements / Data doesn't match user expectation
- data point values
- dimension value, adding to / Adding the dimension value to the data point values
- 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 teams and roles
- about / Data teams and roles
- data research and development (R & D) team / Data research and development
- data governance team / Data governance team
- 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
- Date field / Applying IntervalMatch to the Carrier Decode table
- Days Payable Outstanding (DPO)
- about / Exercise 15.3
- Days Sales of Inventory (DSI)
- about / Days Sales of Inventory, Exercise 15.1
- Days Sales Outstanding (DSO)
- DBMS
- about / Associating data
- default color map
- setting / Setting the default color map
- delimited files
- about / Delimited files
- Deployment Packages artifact / Understanding artifacts
- Dijkstra algorithm
- dimensional data modeling
- about / Dimensional data modeling
- dimensional facts
- creating / Creating dimensional facts
- dimension limits, pie charts / Dimension Limits
- dimensions
- versus facts / Differentiating between facts and dimensions
- denormalizing / Denormalizing dimensions and conformed dimensions
- dimension tables
- designing / Designing dimension tables
- dimension value
- adding, to data point values / Adding the dimension value to the data point values
- 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 Analyzer tool
- URL, for downloading / Reducing the number of columns
- document chaining
- overview / Drilling across with document chaining
- Document Default color map / Setting the default color map
- document level security
- about / Document-level security
- settings / Document-level security
- document level security, settings
- Reduce Data, user privilege / Document-level security
- Add Sheets, user privilege / Document-level security
- Edit Script, user privilege / Document-level security
- Reload, user privilege / Document-level security
- Partial Reload, user privilege / Document-level security
- EditModule, user privilege / Document-level security
- Save Document (Users), user privilege / Document-level security
- Access Document Properties (Users), user privilege / Document-level security
- Promote/Demote Sheets, user privilege / Document-level security
- Allow Export, user privilege / Document-level security
- Allow Print (When Export Is Prohibited), user privilege / Document-level security
- Access Tab row Properties, user privilege / Document-level security
- Macro Override Security, user privilege / Document-level security
- Show All Sheets and Objects, user privilege / Document-level security
- Show Progress for Hidden Script, user privilege / Document-level security
- Allow User Reload, user privilege / Document-level security
- Admin Override Security, user privilege / Document-level security
- document licenses
- about / Data islands
- Document Properties window / The Document Properties window
- design requisites / The Document Properties window
- document requisites, Airline Operations / Document requirements, Creating the new Dashboard sheet
- Dollar-sign expansion
- applying, in script / Applying variables and the Dollar-sign Expansion in the script
- 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 expansions
- nesting / Nesting Dollar-sign Expansions
- drill-down groups
- about / Cyclic and Drill-down groups
- creating / Cyclic and Drill-down groups
- driver types, database connection
- ODBC / Connecting to databases
- OLEDB / Connecting to databases
- custom / Connecting to databases
- Drop statement / Applying IntervalMatch to the Carrier Decode table
- dual / Cartesian joins
- duplicate key values effect
E
- Edit Expression window
- about / The Edit Expression window
- overview / The Edit Expression window
- Fields tab / Fields
- Functions tab / Functions
- Variables tab / Variables
- Images tab / Images
- EditModule, user privilege / Document-level security
- Edit Script, user privilege / Document-level security
- Edit Script window / Hidden script
- E element function
- Enable Transformation Step option
- Enterprise Data Warehouse (EDW)
- about / Dimensional data modeling
- ErrorMode variable
- 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
- Evernote
- URL / Local knowledge base
- example execution
- running / Running an example execution
- Exists clause
- used, for loading QVD / Using an Exists clause
- expression issues, QlikView
- about / Common QlikView expression issues
- row calculation, issues / The expression does not calculate every row
- table, amounts / The amounts in the table are not accumulating
- expression option / The Sort tab
- Expression Overview window
- expressions
- variables, using in / Using variables in expressions
- about / Expressions
- Expressions tab / The Expressions tab
- 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
- URL / Plan to master Qlik Sense data visualization
- External Files artifact / Understanding artifacts
- Extraction, Transform, and Load (ETL) / QlikView Deployment Framework
- extract layer / Two-stage architecture
- extractor folder structure
- Includes subfolder / Creating an extractor folder structure
- QScript subfolder / Creating an extractor folder structure
- QVD subfolder / Creating an extractor folder structure
- Extreme Programming (XP)
- about / Agile development
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
- Field Data button / Using Table Files Wizard
- fields
- comparing, between states / Comparing fields between states
- preloading, into QVDs / Preloading fields into QVDs
- 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
- Fields tab, Edit Expression window / Fields
- 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
- filter pane bubble
- creating / Creating the filter pane bubble, Exercise 19.1
- 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
- First statement / First
- Fixed Number of Columns option / The Presentation tab
- 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
- frequency option / The Sort tab
- from/to dates
- managing, hash used / Using hash to manage from/to dates
- FTEs (Full Time Equivalent)
- about / A refresher
- functions, for counting records
- RecNo() / RecNo
- RowNo() / RowNo
- FieldValueCount / FieldValueCount
- NoOfRows / NoOfRows
- NoOfColumns / NoOfColumns
- Functions tab, Edit Expression window / Functions
- Funnel Chart
- about / Funnel Chart
- Funnel operator / Utility
- fuzzy search / Fuzzy search
G
- gauge charts
- adding, to dashboard sheet / Gauges
- object, cloning for re-use / Cloning the object for re-use
- gauge styles
- about / More Gauge styles
- Gauge Styles tab
- about / More Gauge styles
- GeoQlik
- URL / Market size analysis
- Gestalt principles of perceptual organization
- about / The Gestalt principles of perceptual organization
- proximity / Proximity
- enclosure / Enclosure
- closure / Closure
- connection / Connection
- continuity / Continuity
- similarity / Similarity
- GetCurrentField function / Straight table
- GitHub
- GitHub Gist
- URL / Local knowledge base
- governance / Governance – design template
- 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
- Grid Chart
- about / Grid Chart
H
- hash
- used, for managing from/to dates / Using hash to manage from/to dates
- hash function
- Hash function
- used, for creating composite keys / Using one of the Hash functions
- Help Text option / The Caption tab
- hidden script
- about / Hidden script
- Edit Script window / Hidden script
- adding, to document / Hidden script
- 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
- HighCloud Airlines sample
- about / Merging forces
- objective / The objective
- table, loading / Loading the table
- table, sorting / Sorting the table
- records, peeking into / Peeking previous records
- HighCloud Blue color / Changing the caption colors
- HTML
- tutorials, URL / Plan to master Qlik Sense data visualization
- HTML files
- about / HTML files
- Human resources data model
- about / Human resources data model
- dimensions attributes, changing slowly / Slowing changing dimensions attributes
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
- Idevio
- URL / Market size analysis
- IdevioMaps / Qlik GeoAnalytics
- If $$$ Then $$$ ElseIf construct / If … Then … ElseIf
- image
- displaying, text object used / Using a Text Object to display an image
- image option / Not all expressions are numbers
- Images tab, Edit Expression window / Images
- Import Document Data Wizard window / Reduction fields
- income statement / Income statement, Exercise 13.2
- 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
- incremental load
- about / Incremental loads
- Initial data reduction
- about / Initial data reduction
- setting up, for document / Initial data reduction
- Initial Data Reduction Based on Section Access option / Initial data reduction
- Inline Data Wizard dialog / Section access
- inner join
- about / Inner joins
- Inner Join function / Incremental loads
- Inputs toolbox, dataflow
- installation, jMeter / Installing JMeter
- installation, scalability tools / Installing the scalability tools
- inter-record function
- interactive tutorial
- creating / Creating an interactive tutorial, Exercise 19.2
- IntervalMatch
- applying, to Carrier Decode table / Applying IntervalMatch to the Carrier Decode table
- IntervalMatch function / Applying IntervalMatch to the Carrier Decode table
- using, with SCDs / Using IntervalMatch with SCDs
- intervals, expanding / Expanding the intervals
- applying, steps for / Expanding the intervals
- considerations / Some considerations
- use case / The use case
- IntervalMatch operation / Applying IntervalMatch to the Carrier Decode table
- Intervals tab / Applying IntervalMatch to the Carrier Decode table
- inventory stock levels
- about / Inventory stock levels, Exercise 15.6
- issues
- reporting / Reporting issues
J
- JavaScript
- tutorials, URL / Plan to master Qlik Sense data visualization
- JavaScript library D3
- 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 operation / Applying IntervalMatch to the Carrier Decode table
- 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
- key collision
- Key Performance Indicators (KPIs)
- about / Dashboard users
- 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
- KliqPlan
- about / Planning in QlikView with KliqPlan
- tool extensions, planning / Planning tool extensions
- URL / Planning tool extensions
- sales forecasts and purchase planning / Sales forecasts and purchase planning
- other applications / Other applications
- KliqTable / Sales forecasts and purchase planning
- KliqTable component / Sales forecasts and purchase planning
- KPI straight table
- creating / Straight table
L
- Last function / Using inter-record and range functions
- late arriving dimension values
- dealing with / Dealing with missing or late arriving dimension values
- layer option / The Layout tab
- leaves
- creating, with Hierarchy function / Creating leaves with Hierarchy
- LED gauge option / Not all expressions are numbers
- 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
- linear gauge option / Not all expressions are numbers
- line chart
- about / Line Chart
- versus bar chart / Line Chart
- adding, to analysis sheet / Line Chart
- properties / Additional line chart properties, Presentation
- linked objects
- about / Linked Objects
- creating / Linked Objects
- working / Linked Objects
- precautions, for deleting / Linked Objects
- link option / Not all expressions are numbers
- listboxes
- about / Working with listboxes
- adding / Adding listboxes
- List Box Properties dialog / The List Box Properties dialog
- Multi Box / The Multi Box
- List Box Properties dialog
- General tab / The General tab
- Sort tab / The Sort tab
- Presentation tab / The Presentation tab
- Number tab / The Number tab
- Font tab / The Font tab
- Layout tab / The Layout tab
- Caption tab / The Caption tab
- List Box Properties dialog, Caption tab
- about / The Caption tab
- Multiline Caption option / The Caption tab
- Caption Alignment option / The Caption tab
- Special Icons option / The Caption tab
- Allow Minimize option / The Caption tab
- Auto Minimize option / The Caption tab
- Allow Maximize option / The Caption tab
- Help Text option / The Caption tab
- List Box Properties dialog, Expressions tab
- about / The Expressions tab
- List Box Properties dialog, Font tab
- about / The Font tab
- List Box Properties dialog, General tab
- about / The General tab
- title option / The General tab
- Object ID option / The General tab
- Always One Selected Value checkbox / The General tab
- Show Frequency and In Percent checkboxes / The General tab
- List Box Properties dialog, Layout tab
- about / The Layout tab
- use borders checkbox / The Layout tab
- shadow intensity option / The Layout tab
- border width option / The Layout tab
- rounded corners checkbox / The Layout tab
- layer option / The Layout tab
- Apply To... option / The Layout tab
- Apply Theme option / The Layout tab
- Theme Maker option / The Layout tab
- show option / The Layout tab
- Allow Move/Size option / The Layout tab
- Allow Copy/Clone option / The Layout tab
- List Box Properties dialog, Number tab
- about / The Number tab
- List Box Properties dialog, Presentation tab
- Selection Style Override option / The Presentation tab
- Single Column option / The Presentation tab
- Suppress Horizontal Scroll Bar option / The Presentation tab
- Fixed Number of Columns option / The Presentation tab
- Order by Column option / The Presentation tab
- alignment option / The Presentation tab
- Wrap Cell Text option / The Presentation tab
- List Box Properties dialog, Sort tab
- about / The Sort tab
- state option / The Sort tab
- expression option / The Sort tab
- frequency option / The Sort tab
- numeric value option / The Sort tab
- text option / The Sort tab
- load order option / The Sort tab
- 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
- load order option / The Sort tab
- 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
- Macro Override Security, user privilege / Document-level security
- market size analysis
- Max() function / Aggregation functions
- MaxString() function / Aggregation functions
- Mekko Chart
- about / Mekko Chart
- memory statistics
- exporting, for document / Exporting the memory statistics for a document
- metadata intelligence / Using QlikView Expressor for ETL
- metrics
- adding, to dashboard sheet / Adding a Text object
- Microsoft OneNote
- URL / Local knowledge base
- Min() function / Aggregation functions
- mini chart option / Not all expressions are numbers
- Minimally Viable Products (MVPs)
- minimum viable product (MVP)
- about / Minimum Viable Product
- MinString() function / Aggregation functions
- missing dimension values
- dealing with / Dealing with missing or late arriving dimension values
- Mockaroo
- Customer extract, setting up / Generating dimension values
- modifiers
- defining, as sets / Understanding that modifiers are sets
- Module Password button / Document-level security
- Move/Size Sheet Objects, user privilege / Sheet-level security
- Multi-Transform operator / Transformers
- Multi Box / The Multi Box
- Multiline Caption option / The Caption tab
- 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
- North American Industry Classification System (NAICS) / Marketing data model
- Now() function
- about / Holding dates
- parameters / Holding dates
- NTDOMAIN SID field / Section access fields
- NTNAM field / Section access fields
- NTSID field / Section access fields
- 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 value option / The Sort tab
O
- Object ID option / The General tab
- object properties
- about / Setting the object properties
- caption colors, changing / Changing the caption colors
- Color Area and Color dialog windows / The Color Area and Color dialog windows
- caption font, setting / Setting the caption font
- content font, setting / Setting the content font
- global font, setting / Setting the global font
- default Sheet Object Style, setting / Setting the default Sheet Object Style
- captions, hiding / Hiding captions
- objects
- adding, to report / The Report Editor window
- ODBC
- about / Connecting to databases
- OLEDB
- about / Connecting to databases
- OMIT field / Section access fields
- On-Time and In Full (OTIF)
- about / On-Time and In-Full
- bar chart, creating / Exercise 16.1
- breakdown / OTIF breakdown, Exercise 16.2, Exercise 16.3
- lead time, predicting / Predicting lead time, Exercise 16.4, Exercise 16.5
- supplier and On-Time delivery, correlation / Exercise 16.5
- Online Analytical Processing (OLAP)
- Only() function / Aggregation functions
- Operations.qvw file / Applying the DAR principle to Airline Operations
- operations data model
- about / Operations data model
- multiple date fields, handling / Handling multiple date fields
- Operator Templates artifact / Understanding artifacts
- Order-By fields
- ordering / Ordering the Order-By fields
- Order by Column option / The Presentation tab
- Order By statement / Sorting tables
- 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
- parallel coordinates
- URL / Parallel coordinates
- about / Exercise 14.1, Exercise 14.2
- 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
- parent associations
- creating, with HierarchyBelongsTo function / Creating parent associations with HierarchyBelongsTo
- Pareto analysis / Dimension Limits
- Partial Reload, user privilege / Document-level security
- 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
- PASSWORD field / Section access fields
- Paste Sheet Object as Link command / Linked Objects
- Paste Sheet Object command / Linked Objects
- Peek function
- peek function
- about / The Peek function
- P element function
- periodic snapshot fact tables
- about / Periodic snapshot fact tables
- personal behavior analysis / Personal behavior analysis, Exercise 17.8
- personnel productivity
- about / Personnel productivity, Exercise 17.1, Exercise 17.2
- personnel productivity, breakdown
- about / Personnel productivity breakdown
- age distribution / Age distribution, Exercise 17.3
- salary distribution / Salary distribution, Exercise 17.4
- employee retention rate / Employee retention rate, Exercise 17.5
- employee vacation and sick days / Employee vacation and sick days, Exercise 17.6
- employee training and performance / Employee training and performance, Exercise 17.7
- pie charts
- about / Adding a Pie chart
- adding, to dashboard sheet / Adding a Pie chart
- dimension limits / Dimension Limits
- dimension value, adding to data point values / Adding the dimension value to the data point values
- Pivot Column operator / Transformers
- Pivot Row operator / Transformers
- pivot tables / Adding a new chart
- about / Pivot tables
- creating / Pivot tables
- presentation layer / Two-stage architecture
- Previous function / Previous
- Prohibit Binary Load option / Initial data reduction
- projects
- working with / Working with libraries and projects
- Promote/Demote Sheets, user privilege / Document-level security
- 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
- Q-On Training Center
- Qlik Analytics Platform (QAP) / Qlik Sense Enterprise and the Qlik Analytics Platform, What is the Qlik Analytics Platform?, Qlik Sense and QlikView developers
- Qlik Branch
- Qlik Branch blog
- Qlik community
- Qlik Community
- Qlik Design Blog
- Qlik GeoAnalytics / Qlik GeoAnalytics
- QlikMaps
- URL / Market size analysis
- Qlik Market
- URL / Social media analysis
- Qlik NPrinting / Qlik NPrinting
- Qlik product portfolio
- about / What is new in the Qlik product portfolio?, How do the products in the Qlik product portfolio fit together?
- Qlik Sense Enterprise / Qlik Sense Enterprise and the Qlik Analytics Platform
- Qlik Analytics Platform (QAP) / Qlik Sense Enterprise and the Qlik Analytics Platform, What is the Qlik Analytics Platform?
- QlikView, similar as Qlik Sense / In what way are QlikView and Qlik Sense similar?
- QlikView, different from Qlik Sense / In what way do QlikView and Qlik Sense differ?
- user-perspective / What does this mean for users?
- Qlik NPrinting / Qlik NPrinting
- Qlik Web Connectors / Qlik Web Connectors
- Qlik GeoAnalytics / Qlik GeoAnalytics
- Qlik DataMarket / Qlik DataMarket
- Qlik Sense
- developers / Qlik Sense and QlikView developers
- Qlik Sense 2.2
- Qlik Sense Cloud / In what way do QlikView and Qlik Sense differ?
- Qlik Sense data visualization
- Qlik Sense Desktop / In what way do QlikView and Qlik Sense differ?
- Qlik Sense Enterprise / Qlik Sense Enterprise and the Qlik Analytics Platform
- Qlik Support
- about / Qlik Support
- QlikView
- 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
- user types / User types
- expressions / Expressions
- Edit Expression window / The Edit Expression window, Fields, Images
- Expression Overview window / The Expression Overview window
- Customer Fact sheet / Customer Fact sheet n QlikView
- developers / Qlik Sense and QlikView developers
- QlikView, users
- about / User types
- dashboard users / Dashboard users
- analysts / Analysts
- report users / Report users
- QlikView 12
- Common QIX Engine / Common QIX Engine
- 64-bit / 64-bit only
- online documentation / Online documentation
- references / Online documentation
- security improvements / Security improvements
- mobile touch improvements / Mobile touch improvements
- improved clustering / Improved clustering and scaling
- improved scaling / Improved clustering and scaling
- clustering improvements / Clustering improvements in QlikView 12.1
- QlikView application issues
- about / Common QlikView application issues
- data model issues / Common QlikView data model issues
- expression issues / Common QlikView expression issues
- 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
- URL / Master calendar
- QlikView Components library
- URL / Reusing code
- QlikView data model
- cloning / Cloning a QlikView data model
- QlikView Deployment Framework (QDF)
- QlikView Deployment Framework
(QDF)
- about / QlikView Deployment Framework
- QlikView Development folder
- about / Setting up our environment
- QlikView document
- design requisites / Design requirements
- QlikView extensions
- and cycle plot / QlikView extensions and the cycle plot, Exercise 12.6
- QlikView file / Cloning a QlikView data model
- QlikView File button / Using Table Files Wizard
- QlikView Help / QlikView Help
- QlikView Server cache
- QlikView User Experience (UX)
- customizing / Customizing the QlikView User Experience
- supplementary information, quick access / Quick access to supplementary information, Exercise 18.4
- dynamic data visualization / Dynamic data visualization, Exercise 18.5
- regional settings / Regional settings
- Qlik Web Connectors / Qlik Web Connectors
- 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
- 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
- QVD layer / Two-stage architecture
- QVDs
- about / Three-stage architecture
- QVSource
- URL / Unwanted characters
- QVW
- contents, loading of / Loading the content of another QVW
- QVX Connector connection
- about / Configuring connections
- creating / Creating a QVX Connector Connection
- QVX output
- creating / Creating a QVX output
R
- Radar Chart
- about / Radar Chart
- RAM-stored data / Loading from RAM
- Rand() function / Generating fact table rows
- range function
- 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
- Reduce Data, user privilege / Document-level security
- regional settings
- about / Regional settings
- language / Language
- date and number formats / Date and number formats
- relative paths
- used, for loading files / Using relative paths
- Reload, user privilege / Document-level security
- Reload button / Reduction fields
- Remove Sheet, user privilege / Sheet-level security
- Remove Sheet Objects, user privilege / Sheet-level security
- report
- objects, adding to / The Report Editor window
- aging / Aging report, Exercise 15.7
- Report Editor window
- about / The Report Editor window
- working / The Report Editor window
- options / The Report Editor window
- Report Editor window, options
- Single versus multi page / The Report Editor window
- Report Settings | Header/Footer / The Report Editor window
- Report Settings | Selections / The Report Editor window
- Report Settings | Header/Footer option / The Report Editor window
- Report Settings | Selections option / The Report Editor window
- reports sheet
- about / Creating the Reports sheet
- variable, creating for expression storage / Variables
- tables, creating / KPIs per airline, origin, and destination country, Cyclic and Drill-down groups, Straight table
- pivot tables, creating / Pivot tables
- Auto Minimize option / Auto minimize
- report users
- about / User types, Report users
- repository workspace / Creating a workspace
- Resident load
- about / Resident load
- 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
- RGB() function / The Color Area and Color dialog windows
- right join
- about / Left and right joins
- rotation and average days
- about / Rotation and average days
- rounded corners checkbox / The Layout tab
- RowNo() function / RowNo
- RowNo function / Using inter-record and range functions
- rows
- concatenating / Concatenating rows
S
- sales opportunity analysis
- about / Sales opportunity analysis, Exercise 14.11
- Sankey
- about / Sankey, Exercise 14.4
- extension, URL / Exercise 14.3
- Save Document (Users), user privilege / Document-level security
- 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
- scatter chart
- about / Scatter Chart
- adding, to analysis sheet / Scatter Chart
- 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
- 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
- Script Execution Progress window / Hidden script
- 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
- section access
- about / Section access
- fields / Section access fields
- reduction fields / Reduction fields
- Initial Data Reduction / Initial data reduction
- Initial Data Reduction, setting up for document / Initial data reduction
- fields, omitting / Omitting fields
- Selection Style Override option / The Presentation tab
- Select wizard
- about / The Select wizard
- self-service data layer
- provisioning / Provisioning a self-service data layer
- semi-additive facts
- about / Summing with facts
- SERIAL field / Section access fields
- set
- about / Explaining what we mean by a set
- Set identifiers / Set identifiers
- Set modifiers / Set modifiers
- SET
- versus LET / SET versus LET
- 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
- shadow intensity option / The Layout tab
- sheet handling
- about / Creating the Analysis sheet
- sheet ID property / The Sheet Properties dialog
- sheet level security
- settings / Sheet-level security
- sheet level security, settings
- Add Sheet Objects, user privilege / Sheet-level security
- Remove Sheet Objects, user privilege / Sheet-level security
- Move/Size Sheet Objects, user privilege / Sheet-level security
- Copy/Clone Sheet Objects, user privilege / Sheet-level security
- Access Sheet Object Properties, user privilege / Sheet-level security
- Remove Sheet, user privilege / Sheet-level security
- Access Sheet Properties (Users), user privilege / Sheet-level security
- sheet objects
- selecting / Selecting objects
- moving / Moving objects
- resizing / Resizing objects
- multi box, resizing / Resizing a Multi Box
- aligning / Aligning sheet objects, Do a little house keeping
- Sheet Properties dialog
- about / The Sheet Properties dialog
- General tab / The Sheet Properties dialog
- Fields tab / The Sheet Properties dialog
- Objects tab / The Sheet Properties dialog
- Security tab / The Sheet Properties dialog
- Triggers tab / The Sheet Properties dialog
- Sheet Properties dialog, General tab
- title property / The Sheet Properties dialog
- show sheet property / The Sheet Properties dialog
- sheet ID property / The Sheet Properties dialog
- background property / The Sheet Properties dialog
- tab settings property / The Sheet Properties dialog
- Sheet Properties dialog, Objects tab / The Sheet Properties dialog
- Sheet Properties dialog, Security tab / The Sheet Properties dialog
- Sheet Properties dialog, Triggers tab / The Sheet Properties dialog
- sheets
- copying / Copying sheets
- Show All Sheets and Objects, user privilege / Document-level security
- Show Frequency and In Percent checkboxes / The General tab
- show option / The Layout tab
- Show Progress for Hidden Script, user privilege / Document-level security
- show sheet property / The Sheet Properties dialog
- similar files
- loading, with concatenation / Loading similar files with concatenation
- Single Column option / The Presentation tab
- Single versus multi page option / The Report Editor window
- slow changing dimension
- slow changing dimensions
- about / Dealing with slowly changing dimensions
- Carrier Decode table / The Carrier Decode table
- Slowly Changing Dimensions (SCD) attributes / Slowing changing dimensions attributes
- snowflake schema / Understanding star schemas
- social media analysis
- Sort operator / Utility
- source layer / Two-stage architecture
- sparklines
- about / Sparklines, Exercise 18.3
- Special Icons option / The Caption tab
- SQL Query operator / Inputs
- standalone workspace / Creating a workspace
- star schemas
- about / Understanding star schemas
- state option / The Sort tab
- states
- fields, comparing between / Comparing fields between states
- state space / The QlikView calculation engine
- statistics box
- about / Statistics box
- adding, to analysis sheet / Statistics box
- StoreAndDrop subroutine
- creating / Creating a StoreAndDrop subroutine
- straight table
- about / Straight table
- versus table box / Straight table
- straight tables
- options / Not all expressions are numbers
- straight tables, options
- image / Not all expressions are numbers
- circular gauge / Not all expressions are numbers
- linear gauge / Not all expressions are numbers
- traffic light gauge / Not all expressions are numbers
- LED gauge / Not all expressions are numbers
- mini chart / Not all expressions are numbers
- link / Not all expressions are numbers
- 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
- Strategy Map / The Balanced Scorecard method
- Strict Exclusion option / Initial data reduction
- string concatenation
- used, for creating composite keys / Using string concatenation
- subroutines
- about / Subroutines
- example / Subroutines
- sum() function / Aggregation functions
- Sum function
- about / Summing with facts
- Sum of If / Sum of If
- Suppress Horizontal Scroll Bar option / The Presentation tab
- 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 box
- versus straight table / Straight table
- 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
- creating / KPIs per airline, origin, and destination country, Cyclic and Drill-down groups, Straight table
- sorting / Sorting tables
- Order-By fields, ordering / Ordering the Order-By fields
- Tab Rename Dialog window / Loading the table
- tab settings property / The Sheet Properties dialog
- 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
- text object
- used, for displaying image / Using a Text Object to display an image
- actions, adidng to / Adding actions to a Text object
- text objects
- about / Adding a Text object
- creating / Adding a Text object
- text option / The Sort tab
- The Data Warehouse Toolkit
- Theme Maker option / The Layout tab
- three-stage architecture
- about / Three-stage architecture
- Transformation Layer / Three-stage architecture
- Transformed QVD Layer / Three-stage architecture
- TimeStamp() function
- about / Holding dates
- title option / The General tab
- title property / The Sheet Properties dialog
- 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
- TRACE statement / Hidden script
- traffic light gauge option / Not all expressions are numbers
- transaction fact table
- about / Transaction fact tables
- Transformation Layer / Three-stage architecture
- Transformation operation
- configuring / Adding a Transformation operation
- transformation output / The Transformation output
- Transformed QVD Layer / Three-stage architecture
- transformer operator, dataflow
- Aggregate / Transformers
- Join / Transformers
- Transform / Transformers
- Multi-Transform / Transformers
- Pivot Row / Transformers
- Pivot Column / Transformers
- Transform operator / Transformers
- Trash operator / Outputs
- Trellis Chart
- about / Trellis Chart
- troubleshooting
- preparing for / Troubleshooting preparation and resources, Positive mindset
- debugging skills, general / General debugging skills
- reproduce / Reproduce
- diagnose / Diagnose
- issue, fixing / Fix
- reflect / Reflect
- resources / Resources
- QlikView Help / QlikView Help
- local knowledge base / Local knowledge base
- Qlik Community / Qlik Community
- Qlik Support / Qlik Support
- two-stage architecture
- about / Two-stage architecture
- source layer / Two-stage architecture
- extract layer / Two-stage architecture
- QVD layer / Two-stage architecture
- presentation layer / Two-stage architecture
- 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
- Unicode geometric shapes
- Unique operator / Utility
- Unless statement
- about / When and Unless
- use borders checkbox / The Layout tab
- use cases, variables
- dates, holding / Holding dates
- paths, holding / Holding paths
- USERID field / Section access fields
- utility operators, dataflow
V
- variable
- creating / Variables
- 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
- Variables tab, Edit Expression window / Variables
- 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
- What-If scenarios
- about / Analysts
- 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
- Word Cloud extension
- URL / Exercise 14.10
- workspace
- about / Creating a workspace
- standalone workspace / Creating a workspace
- repository workspace / Creating a workspace
- creating / Creating a workspace
- Wrap Cell Text option / The Presentation tab
- 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
- XmR charts
- about / Measuring success with XmR charts
- creating / Exercise 19.3
Y
- Year-over-Year (YOY) growth / The financial perspective
- Year-to-Date (YTD) growth / The financial perspective