QlikView Developer

• Script Editor
• Loading Data to Qlikview using Excel Files
• Connecting to ODBC or OLEDB Data Sources
• Loading Data from Other Data Sources
• Relative Paths
• Reload,
• Partial Reload
• Debugger
• Creating and Working with QVD files
• Data Model, Script Editor and Table Viewer
• Load Statements (Inline Loads, Binary Loads)
• Joining Tables Where Exists
• Table Concatenation
• Synthetic Keys and Synthetic Tables
• Cross table
• Mapping loads
• Apply Map Method
• Interval Match
• Aggregation Functions
• PEEK
• FirstSortedValue, Hirerachy,
• Set and Let Statements
• Security Overview
• Best Practices

QlikView Designer

• Sheets and Sheet Objects
• Layout Design
• The Current Selections, Search and Statistics Objects
• The List Box
• The Table Box
• Creating Links and Removing Unwanted Links
• Expressions and Dimensions
• Editing Expressions
• Set Analysis
• Straight and Pivot Tables
• Bar Charts
• Text, Line, Button and Action Objects
• The Multi Box
• Pie, Block and Funnel Charts
• Line Charts and Combo Charts
• Mini Charts, Trellis Charts
• Dynamic Text
• Gauges
• Working with Variables
• Best Practices

QlikView Administration

• QMC Introduction and Overview
• Managing Folders
• Creating Tasks
• Scheduling Tasks
• Adding Users to Documents