Duration
3 days
OVERVIEW
QlikView Designer & Developer Fast Track is a scenario based course covering the fundamentals required to get started building QlikView applications. The course is a mixture of demonstrations and hands-on exercises which include user interface layout, design fundamentals, how to create a QlikView application with sheets and charts as well as best practices in design. In addition, this course also provides knowledge of the data model, creation of the proper data connections and scripting fundamentals. It provides you with an opportunity to learn by doing through a series of lectures and hands on exercises focused on developing QlikView applications.
COURSE OUTLINE
Qlikview Designer
GET STARTED WITH QLIKVIEW
Qlikview’s Graphical Interface
Basic Elements
Settings and Preferences
THE ABC SALES APPLICATION
The ABC Sales Business Plan
The Sales Application
User Stories
The Data, Measures and KPIs
The D-A-R concept
THE DATA MODEL
The .QVW format
Loading Data from different Data Sources
QVD
Data Structure in QlikView
SHEETS, FILTERS AND NAVIGATION
Sheets and Sheet objects
Sheet Properties
Design Toolbar
Filters: Current Selections, List Box, Search Object,
Multi Box
FOUNDATIONS OF A POWERFUL INTERFACE
Visual Perception
Less is More
Resolution
Fonts, Layout & Hierarchy
DISCOVERING CHARTS
Dimensions and Expressions
Chart Components
Best Practices
What Chart to Use?
Trellis Chart
Dimension Limits
Movements and Trends
Gauge Chart
Fast Type Change
Containers
Table Design
Table Box
Selections, Sorting and filters in Tables
Alignment of Columns
Pivot Table
Straight Table
Mini Charts
ADVANCED INTERFACE DESIGN
Other Use of Expressions
Calculated Labels and Dynamic Texts
Displaying KPIs
Use of Flags
Conditional Functions
Calculated Fields and Dimensions
Variables
Set analysis – Basic
MULTI SCREEN DEVELOPMENT
Differences in UI
Webview
Extensions
Qlikview Developer
QLIKVIEW DEVELOPMENT METHODOLOGY
Import/Export sheet and document layouts as XML
QPM
DEPLOYMENT
Qlikview Desktop, Server, and Publisher
Example Deployments
I NTRODUCTION TO DATA AND SCRIPTING
Data Structures
The Table Files Wizard
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
CONNECT, SELECT AND LOAD
Creating a connection to database
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
GENERATING DATA IN THE QLIKVIEW SCRIPT
Resident Load The Where Exists Clause
Include Statement
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
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
Aggregating Data
CROSS TABLES AND INPUT FIELD
Cross Tables
The For Loop
Input Fields
SCRIPTING AND DATA MODELLING CHALLENGES
Link Tables
Class
Dynamic Aggregation
Interval Match
Data Market Connector and Data Islands
ADVANCED CALCULATIONS IN SHEET OBJECTS
Perform comparative analysis using Alternate States
Set Analysis
Dollar-Sign Expansion & Aggr Function
QLIKVIEW DATA FILES (QVD)
About QVD
QVD File Format
Use of QVD
Creating QVD Files
PERFORMANCE OPTIMIZATION (Optional)
Performance Tuning
Best Practices for QlikView File Optimization
QLIKVIEW SECURITY (Optional)
Access control
Access levels
Access control database
Inherited access restrictions
Hidden script
Adding Section Access
Access Control for Certain Commands
COURSE PREREQUISITES
None
AUDIENCE
QlikView Designers
QlikView Developers
Programme scope, delivery arrangements and suitability are confirmed during enquiry.