This three-day classroom course is recommended for power users, developers and IT staff that will be developing new or enhancing or maintaining existing QlikView applications. The session covers scripting, data source integration, and advanced GUI development. This module requires a basic working knowledge of databases and SQL.
Schedule
Course times daily:
9:00am to 5:00pm.
Content daily outline
Day 1
- QlikView Introduction
- Versions
- Installation
- Project Plan
- Data Sources
- Star Schema
- Smart Structure
- User Settings
- Document Settings
- Script Editor
- Syntax
- SQL vs QlikView
- Preceding Load
- Connect
- Linking Tables
- How to "drive" QlikView
- Correct interpretation of QlikView
- Selecting data
- Clearing selections
- Search
- Bookmarks
- Bookmark Objects
- Export Data
- Debugger
- Logfiles
- Dimensions
- Create System Tab
- System Fields
- Synthetic Keys – how to avoid
- Loops
- Autonumber function
- Loading data from Excel files
- Loading data from XML files
- Key Fields
Day 2
- Mapping loads
- Cleaning up table structure
- Listbox Expression
- Extended listbox functionality
- QVD Exports
- Front End best practices
- Table Box
- Charts
- Calendar
- Transformation of data using QlikView functions
- Variables
- Container Objects
- Fiscal periods
- Resident loads
- Where function
- Different ways of joining tables
- Inline loading
- Autogenerate
Day 3
- Buttons
- Macros
- Loading Budgets
- Cross tables
- Input fields
- Security
- Sorting in charts
- Selecting in charts
- Cycle Groups
- Drop down select in charts
- Pivot tables
- Reports
- Set Analysis
- Trouble-Shooting
- Advanced scripting