Course Content
USING QLIKVIEW
- Starting QlikView
- Basic Layout and Navigation
SHEETS AND SHEET OBJECTS
- Sheet Basics
- Sheet Objects
- Exercise Creating Your Workspace
LOADING DATA INTO QLIKVIEW
- Script editing
- Edit Script Toolbar
- Edit Script Menu Commands
- Statements Area
CREATING THE SCRIPT
- Script generation
- Creating a connection to the database
- Reading tables into QlikView
SCRIPTING CONSIDERATIONS and Data Modeling
- Reading the QWT MDB
- Synthetic key tables
- Circular references
- Causes of circular references
- Loosely Coupled Tables
LOADING AN XML FILE
- Loading a text file in XML Format
- Renaming fields using the Qualify statement
ENERATING DATA IN THE QLIKVIEW SCRIPT
- Resident Load
- Inline tables
- Auto generate tables
MAPPING TABLES
- Mapping Quarters to the Orders table
- Month Year
- Cleaning up the table structure
QLIKVIEW DATA (QVD) FILES
QLIKVIEW SECURITIES
ADVANCED SCRIPTING
SET ANALYSES
COMPARATIVE ANALYSES
MOST OF THE UNKNOWN QLIKVIEW FUNCTIONS
ALERETS AND TRIGGERS
REPORTS FOR PDF
