Index
A
- access point
- URL, structure / QlikView architecture essentials
- Adventure Works Cycles / About Adventure Works
- Aggr function / The Aggr function
- Alternate States
- about / Alternate States
- application deployment
- about / QlikView application deployment
- steps / QlikView application deployment
- architecture, QlikView
- about / QlikView architecture essentials
- QlikView Server (QVS) / QlikView architecture essentials
- publisher / QlikView architecture essentials
- QlikView Management Console (QMC) / QlikView architecture essentials
- Access Point / QlikView architecture essentials
- QlikView clients / QlikView architecture essentials
- automatic concatenation
- about / Concatenation, Automatic Concatenation
B
- bar chart
- creating / Creating a bar chart
- Expression Overview / Expression Overview
- best practices, data modeling
- associations / Best practices of data modeling
- binary load
- about / Binary load
- menu items, exploring / Exploring menu items
C
- charts
- about / Some more charts
- line charts / Line charts
- combo charts / Combo charts
- pie chart / Pie charts
- circular reference
- Client User Licenses (CALs)
- about / Client Access Licenses (CALs)
- Named User CAL / Client Access Licenses (CALs)
- document CAL / Client Access Licenses (CALs)
- session CAL / Client Access Licenses (CALs)
- usage CAL / Client Access Licenses (CALs)
- combo charts / Combo charts
- concatenation
- about / Concatenation
- automatic concatenation / Concatenation
- forced concatenation / Concatenation
- no concatenate / Concatenation
- example / Concatenation example
- configuring settings, QlikView / Configuring settings
- CountryRegion_Inline table / Mapping load – CountryRegion_Inline
- Crosstable
- about / Crosstable essentials
- Customer table
- loading / Loading the Customer table
D
- dashboard
- essentials / Dashboarding essentials
- creating / Getting started
- data association / Associative experience
- binary load / Binary load
- dashboard sheet
- about / The dashboard sheet
- logo, placing / Placing a logo on the dashboard sheet
- data
- loading, from Excel files / Loading data from text and Excel files
- loading, from text / Loading data from text and Excel files
- database
- data, loading from / Connecting to the database
- OrderHeader table, loading / Loading the OrderHeader Table
- OrderDetail table, loading / Loading the OrderDetail table
- fields, creating in Order table / Creating fields in the Order table
- Customer table, loading / Loading the Customer table
- Product table, loading / Loading the Product table
- synthetic keys, resolving / Resolving the synthetic keys
- synthetic keys between Product and Order Detail tables. removing / Removing synthetic keys between the Product and Order Detail tables
- ProductSubCategory table, loading / Loading the ProductSubcategory table
- data, loading from text / Loading data from text and Excel files
- data, loading from Excel files / Loading data from text and Excel files
- ProductCategory table, loading / Loading the Product Category table
- Employee.xlsx, loading / Loading Employee.xlsx
- circular reference / Circular reference and loosely coupled tables
- loosely coupled tables / Circular reference and loosely coupled tables
- SalesTerritory table, loading / Loading the SalesTerritory and Shipment tables
- Shipment table, loading / Loading the SalesTerritory and Shipment tables
- Inline table, loading / Loading an Inline table
- Qualify statement / The Qualify statement
- Shippers table, loading / Loading the Shippers table
- resident load / A word about resident load and Exists
- Exists / A word about resident load and Exists
- sales person, searching / Finding the sales person
- If statements, using in script / Using If statements in the script
- Include statement, used for including files / Including files using the Include statement
- Table Viewer / More on Table Viewer
- data model, reviewing / Time to review your data model so far
- data model
- reviewing, time / Time to review your data model so far
- QlikView Data (QVD) files, adding / Creating QVD files for our data model
- data model/data sources
- analyzing / Analyze data model/data sources
- snow flake schema / Star schema and snow flake schema
- Star schema / Star schema and snow flake schema
- data modeling
- best practices / Best practices of data modeling
- development life cycle
- about / The development life cycle of QlikView implementations
- Adventure Works Cycles / About Adventure Works
- user requirements / User requirements
- data model/data sources, analyzing / Analyze data model/data sources
- development setup
- about / QlikView development setup
- Apps folder / QlikView development setup
- Data folder / QlikView development setup
- Images folder / QlikView development setup
- Includes folder / QlikView development setup
- dimension limits
- about / Dimension limits
- using / Dimension limits
- interactivity, text objects used / Interactivity using text objects
- document CAL / Client Access Licenses (CALs)
E
- Employee.xlsx
- loading / Loading Employee.xlsx
- EmployeeSalesTarget.xlsx
- loading / Loading EmployeeSalesTarget.xlsx
- Excel files
- data, loading / Loading data from text and Excel files
- Exists / A word about resident load and Exists
F
- fields
- creating, in Order table / Creating fields in the Order table
- file path
- setting, with variables / Using variables to set the file path
- files
- including, with Include statement / Including files using the Include statement
- final data model
- reviewing / Reviewing the final data model
- forced concatenation
- about / Concatenation, Forced concatenation
- functions
- about / Some important functions
- Aggr function / The Aggr function
- nested aggregation functions / Nested aggregation
- GetSelectedCount function / Other functions
- GetFieldSelections function / Other functions
G
- GetFieldSelections function / Other functions
- GetSelectedCount function / Other functions
I
- identifiers, Set Analysis
- Sum({$}LineSalesAmount) function / Set Analysis essentials
- Sum({$1}LineSalesAmount) function / Set Analysis essentials
- Sum({1}LineSalesAmount function / Set Analysis essentials
- Sum({BkMrk1}LineSalesAmount) function / Set Analysis essentials
- Sum({State 1}LineSalesAmount) function / Set Analysis essentials
- If statements
- using, in script / Using If statements in the script
- Include statement
- used, for including files / Including files using the Include statement
- Inline table
- loading / Loading an Inline table
- input box, What-If Analysis
- using / Using input box
- installation
- QlikView / QlikView installation
- IntervalMatch function
- using / The IntervalMatch function
J
- joins
- about / Joins
- working / Joins
- inner join / Joins
- left join / Joins
- right join / Joins
- outer join / Joins
- Order Detail / Join Orders and Order Detail
- Order / Join Orders and Order Detail
- Left join SalesPerson / Left join SalesPerson
- data, aggregating / Aggregating data
- new Employees table, concatenating / Concatenating the new Employees table
K
- key performance indicators (KPIs) / Dashboarding essentials
L
- line charts / Line charts
- link table
- about / Link table
- creating, steps / Link table essentials
- creating / Creating a link table
- list boxes
- creating / Creating list boxes for other fields
- objects, copying / Options to copy and paste objects
- objects, pasting / Options to copy and paste objects
- logo, placing on dashboard sheet / Placing a logo on the dashboard sheet
- loosely coupled tables
M
- mapping load
- Territory table / Mapping load – Territory table
- ProductSubcategory table / Mapping load – Product Category and ProductSubcategory tables, Mapping load – ProductSubcategory table
- Product Category table / Mapping load – Product Category and ProductSubcategory tables
- CountryRegion_Inline table / Mapping load – CountryRegion_Inline
- mapping table
- about / Mapping table essentials
- properties / Mapping table essentials
- components / Mapping table essentials
- master calendar
- about / Master calendar
- multi-tab application
- creating / Creating a multi-tab application
- dashboard sheet / The dashboard sheet
- list boxes, creating for other fields / Creating list boxes for other fields
- objects, copying / Options to copy and paste objects
- objects, pasting / Options to copy and paste objects
- logo, placing on dashboard sheet / Placing a logo on the dashboard sheet
N
- Named User CAL / Client Access Licenses (CALs)
- no concatenate
- about / Concatenation, NoConcatenate
O
- OMIT
- used, for implementing Section Access / Using OMIT
- optimized load
- about / Optimized load – reading QVD
- conditions / Optimized load – reading QVD
- OrderDetail table
- loading / Loading the OrderDetail table
- OrderHeader table
- loading / Loading the OrderHeader Table
- Order table
- fields, creating / Creating fields in the Order table
P
- pie charts / Pie charts
- pivot table
- about / The story of two tables
- creating / Creating a pivot table
- container / Container
- Product Category table / Mapping load – Product Category and ProductSubcategory tables
- ProductCategory table
- loading / Loading the Product Category table
- ProductSubCategory table
- loading / Loading the ProductSubcategory table
- ProductSubcategory table / Mapping load – Product Category and ProductSubcategory tables, Mapping load – ProductSubcategory table
- Product table
- loading / Loading the Product table
Q
- QlikView
- installation / QlikView installation
- installation, URL / QlikView installation
- about / Getting started
- development life cycle / The development life cycle of QlikView implementations
- development setup / QlikView development setup
- configuring settings / Configuring settings
- variables / Variables in QlikView
- variables, used for setting file path / Using variables to set the file path
- architecture / QlikView architecture essentials
- application deployment / QlikView application deployment
- server structure / QlikView server structure
- QlikView components
- Desktop / QlikView components
- Server / QlikView components
- Publisher / QlikView components
- QlikView Data (QVD) files
- about / QlikView Data Files (QVD), Reading QVD files
- creating, for data model / Creating QVD files for our data model
- reading / Optimized load – reading QVD, Reading QVD files
- QlikView Management Console (QMC) / QlikView application deployment
- Qualify statement / The Qualify statement
R
- reduction field
- used, for implementing Section Access / Using reduction
- resident load / A word about resident load and Exists
S
- sales person
- searching / Finding the sales person
- SalesTerritory table
- scatter chart
- creating / Creating a scatter chart
- script editor
- highlights / Scripting essentials
- scripting
- about / Scripting essentials
- Section Access
- about / Section Access essentials
- implementing / Section Access essentials, Implementing Section Access
- access rights implementation, criteria / Section Access essentials
- implementing, OMIT used / Using OMIT
- implementing, reduction field used / Using reduction
- server structure
- tabs / QlikView server structure
- session CAL / Client Access Licenses (CALs)
- Set Analysis / Creating a straight table
- about / Set Analysis essentials
- scenarios / Set Analysis essentials
- identifier / Set Analysis essentials
- set operators / Set Analysis essentials
- modifiers / Set Analysis essentials
- using / Using Set Analysis
- set operators, Set Analysis
- + (Union) / Set Analysis essentials
- - (Exclusion) / Set Analysis essentials
- * (Intersection) / Set Analysis essentials
- / (Symmetric) / Set Analysis essentials
- sheet objects / Sheet objects
- Shipment table
- Shippers table
- loading / Loading the Shippers table
- snow flake schema / Star schema and snow flake schema
- Star schema
- facts / Star schema and snow flake schema
- dimensions / Star schema and snow flake schema
- straight table
- about / The story of two tables
- creating / Creating a straight table
- enhancing / Enhancing your tables
- groups / Groups
- drill-down group, creating / Creating a drill-down group
- cyclic group, creating / Creating a cyclic group
- pivot table, creating / Creating a pivot table
- synthetic keys
- resolving / Resolving the synthetic keys
- between Product and Order Detail tables, removing / Removing synthetic keys between the Product and Order Detail tables
T
- tables
- straight table / The story of two tables
- pivot table / The story of two tables
- Table Viewer / More on Table Viewer
- Territory table / Mapping load – Territory table
- text object
- creating / Creating a text object
U
- usage CAL / Client Access Licenses (CALs)
V
- variables, QlikView
- about / Variables in QlikView
- used, for setting file path / Using variables to set the file path
- visualization application
- last step / The last step
W
- What-If Analysis
- about / What-If Analysis
- input box, using / Using input box