Course Content
QLIKVIEW DEVELOPMENT METHODOLOGY
DEPLOYMENT
- QlikView Desktop, Server and Publisher
INTRODUCTION TO DATA AND SCRIPTING
- QlikView's QVD File and format
- Comparing Database Structures to QlikView Data
- Structures
- Data Structures in QlikView
- QlikView Data Modeling
- Introduction to Scripting
- The QWT Project Data, Primary & Secondary Data Source
LOADING DATA FROM THE DATABASE
- Script Generation
- Comments in the Script
- The Create Select Statement Dialog
- Creating Tabs in the Script
- Script Debugging
- The Script Execution Log File
SYNTHETIC KEYS
BASIC DATA MODEL AND TABLE VIEWER
ADDING TEXT DATA
- The File Wizard
- Your Excel Files
- Script generation using the File Wizard
BASIC DATA TRANSFORMATION
- Load Statement
- Renaming a Field
- Script Expressions
- Loading an XML File
- The Qualify Statement, Key Fields, Count and Sum
LOADING BUDGET DATA
- Cross Tables and Input field
ADVANCED CALCULATIONS IN SHEET OBJECTS
- Dimension Limits
- Perform comparative analysis using Alternate
- States
- Set Analysis
- Dollar-Sign Expansion & Aggr Function
META DATA
- Tags, Comments & Renaming
- Null functions
- HidePrefix & HideSuffix
QLIKVIEW DATA (QVD) FILES
- QVD File Format and its use
- Creating QVD Files
- Store Statement
- Manual Creation of a QVD File in the Script
GENERATING DATA IN THE QLIKVIEW SCRIPT
- Resident Load
- The Where Exists Clause
SCRIPTING CONSIDERATIONS
- More about Synthetic Keys
- Synthetic Key Tables
- Composite Keys
- Circular References
- Loosely Coupled Tables
- Eliminating Circular Reference
MASTER CALENDAR
- Date and Time
- The Master Calendar
- Using Flags
- Data & Date Islands
MAPPING TABLES
- Mapping Tables
- Cleaning up the Table Structure
- Preceding Load on Preceding Load
DATA MODEL OPTIMIZATION
- How to Create QlikView Data Models
- Joining tables
- Concatenation
- From Snow Flake to Star Scheme
- Merged Facts Table
- Aggregating Data
SCRIPTING AND DATA MODELING CHALLENGES
- Link Tables and Concatenated Tables
- Calculating Net Change within a Field
- Dynamic Aggregation
PERFORMANCE OPTIMIZATION
- Performance Tuning
- Best Practices for QlikView File Optimization
QLIKVIEW SECURITY
- Access control
- Access levels
- Access control database
- Inherited access restrictions
- Hidden script
- Adding Section Access
- Access Control for Certain Commands
- Further access control
- Unattended Command Line Reload Considerations
- Access restrictions on selected field values
- Field value limitation in Section Access