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
- actions
- additive 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
- Advanced Color Map dialog window / Setting the default color map
- advanced search / Advanced search
- advanced Table File Wizard options
- After function / Using inter-record and range functions
- Aggr
- Aggregate operator / Transformers
- aggregation functions
- Aggr function / Creating advanced aggregations with Aggr
- agile development
- Airline Operations
- Air Time % gauge
- AlchemyAPI
- 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
- Always One Selected Value checkbox / The General tab
- analysis sheet
- analysts
- ApplyMap
- Apply Theme option / The Layout tab
- Apply To... option / The Layout tab
- Apply to All Sheets checkbox / Sheet-level security
- Apriori
- artifacts
- AsOfCalendar / AsOfCalendar
- associative model
- associative search / Associative search
- Atlassian Confluence
- Atomic type
- AutoGenerate
- AutoGenerate() function / Generating fact table rows
- automatic interpretation, of searches
- Auto Minimize option / The Caption tab, Auto minimize
- AutoNumber function / Executing transformers
- AutoNumber script function / Understanding synthetic keys
- Available Fields listbox / The Sheet Properties dialog
- Average Inventory Value / Working capital breakdown
B
C
D
- DAR principle
- Dashboards
- dashboard sheet
- dashboard sheets
- dashboard users
- data
- data, loading
- data architecture
- Database connection
- database connection
- data exploration
- data extraction, ETL approach
- dataflow
- Dataflow artifact / Understanding artifacts
- dataflow toolbox
- Data Interchange Format (DIF) / Delimited files
- data islands / Data islands
- data loading concepts
- data load steps, ETL approach
- data model
- data model, financial perspective
- data model, sales perspective
- data model issues, QlikView
- data point values
- Datascript Modules artifact / Understanding artifacts
- data storage, QlikView
- data teams and roles
- data transformation, ETL approach
- datatypes, QlikView
- data visualization
- Date field / Applying IntervalMatch to the Carrier Decode table
- Days Payable Outstanding (DPO)
- Days Sales of Inventory (DSI)
- Days Sales Outstanding (DSO)
- DBMS
- default color map
- delimited files
- Deployment Packages artifact / Understanding artifacts
- Dijkstra algorithm
- dimensional data modeling
- dimensional facts
- dimension limits, pie charts / Dimension Limits
- dimensions
- dimension tables
- dimension value
- dimension values
- Direct Discovery
- direct field comparison / Direct field comparison
- DirList function / DirList
- dissimilar files
- Do $$$ Loop statement
- document
- Document Analyzer tool
- document chaining
- Document Default color map / Setting the default color map
- 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
- Document Properties window / The Document Properties window
- document requisites, Airline Operations / Document requirements, Creating the new Dashboard sheet
- Dollar-sign expansion
- Dollar-sign Expansion
- Dollar-sign expansions
- drill-down groups
- driver types, database connection
- Drop statement / Applying IntervalMatch to the Carrier Decode table
- dual / Cartesian joins
- duplicate key values effect
E
F
G
- gauge charts
- gauge styles
- Gauge Styles tab
- GeoQlik
- Gestalt principles of perceptual organization
- GetCurrentField function / Straight table
- GitHub
- GitHub Gist
- governance / Governance – design template
- grain
- grains
- Grid Chart
H
- hash
- hash function
- Hash function
- Help Text option / The Caption tab
- hidden script
- HierarchyBelongsTo function
- Hierarchy function
- HighCloud Airlines sample
- HighCloud Blue color / Changing the caption colors
- HTML
- HTML files
- Human resources data model
I
J
K
L
M
N
O
P
Q
R
S
- sales opportunity analysis
- Sankey
- Save Document (Users), user privilege / Document-level security
- scalability
- scalability tools
- scatter chart
- SCDs
- schema
- Schemas artifact / Understanding artifacts
- script
- script, types
- script constructs
- script debugger
- ScriptErrorCount variable / ScriptErrorCount and ScriptErrorList
- ScriptErrorList variable / ScriptErrorCount and ScriptErrorList
- ScriptError variable / ScriptError
- Script Execution Progress window / Hidden script
- searches
- searching, in QlikView
- section access
- Selection Style Override option / The Presentation tab
- Select wizard
- self-service data layer
- semi-additive facts
- SERIAL field / Section access fields
- set
- SET
- Set Analysis / Optimizing performance by creating counter fields, Set Analysis
- Set Analysis, with Alternate States
- Set arithmetic operators
- Set identifiers
- SET keyword
- Set modifiers / Set modifiers
- Set statement / Applying variables and the Dollar-sign Expansion in the script
- shadow intensity option / The Layout tab
- sheet handling
- sheet ID property / The Sheet Properties dialog
- sheet level security
- sheet level security, settings
- sheet objects
- Sheet Properties dialog
- Sheet Properties dialog, General tab
- 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
- 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
- Single Column option / The Presentation tab
- Single versus multi page option / The Report Editor window
- slow changing dimension
- slow changing dimensions
- 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
- Special Icons option / The Caption tab
- SQL Query operator / Inputs
- standalone workspace / Creating a workspace
- star schemas
- state option / The Sort tab
- states
- state space / The QlikView calculation engine
- statistics box
- StoreAndDrop subroutine
- straight table
- straight tables
- straight tables, options
- strategies, for reducing data size / performance improvement
- Strategy Map / The Balanced Scorecard method
- Strict Exclusion option / Initial data reduction
- string concatenation
- subroutines
- sum() function / Aggregation functions
- Sum function
- Sum of If / Sum of If
- Suppress Horizontal Scroll Bar option / The Presentation tab
- surrogate keys
- Switch $$$ Case construct / Switch … Case
- synthetic key
T
U
V
- variable
- variables
- variables, in QlikView
- Variables tab, Edit Expression window / Variables
- variable values
- vertical calculation
- vertically
W
X
Y
..................Content has been hidden....................
You can't read the all page of ebook, please click
here login for view all page.