INTRODUCTION

• Target Audience
• What You Will Learn in this Course
• Course Logistics
• Notes

QLIKVIEW ENVIRONMENT

• QlikView Desktop

QLIKVIEW DEVELOPMENT METHODOLOGY

• Import/Export Sheet and Document Layouts as XML
• Qlik Wholesale Trade (QWT) Project Plan
• Project Plan Review
• SAFE Methodology

DEPLOYMENT

• QlikView Standalone
• QlikView Server
• QlikView Publisher

INTRODUCTION TO DATA AND SCRIPTING

• Relational Databases
• Other Data Structures
• Comparing Database Structures to QlikView Data Structures
• Data Structures in QlikView
• Data Source Files
• The QWT Primary Data Source
• The QWT Secondary Data Files
• Introduction to Scripting

BASIC SCRIPT SYNTAX

• Syntax

LOADING DATA FROM THE DATABASE

• Script Generation
• Comments in the Script
• Script Debugging

STRUCTURING THE SCRIPT

• Creating Tabs in the Script

BASIC DATA MODEL AND TABLE VIEWER

• The Table Viewer
• The System Table
• Document Properties: Tables page

BASIC DATA TRANSFORMATION

• Load Statement
• Renaming a Field
• Script Expressions
• Loading an XML File
• Renaming Fields Using the Qualify Statement
• Key Fields
• Example Predicament
• How Does this Affect You?
• Loading a Field into a Table Multiple Times
• Using a Record Counter on Key Fields
• Is it Correct?

ADDING TEXT DATA

• Employees
• Offices
• Script generation using the File Wizard

GENERATING DATA IN THE QLIKVIEW SCRIPT

• Resident Load
• Using Orders to determine Sales Person.
• Include
• Time Functions: Creating a Calendar
• Getting the Highest and Lowest Date from the Orders Table
• Autogenerate tables
• Creating Variables in the Script
• The Master Calendar

SCRIPTING CONSIDERATIONS

• Synthetic Key Tables
• Circular References
• Causes of Circular References
• Check the Numbers

QLIKVIEW DATA (QVD) FILES

• QVD File Format
• Use of QVD Files
• Creating QVD Files
• Manual Creation of a QVD File in the Script
• Automatic Creation of a QVD File in the Script
• QVD File Script Functions

REPORTING BUGS IN QLIKVIEW

ADDITIONAL INFORMATION

• Reference Materials
• Data types in QlikView 137

APPENDIX: LAYOUT BASICS FOR DEVELOPERS

• User Friendly Design
• Natural Human Behavior
• Chart and Object Choices in QlikView
• Import/Export Sheet and Document Layouts

APPENDIX: The Completed Script

INTRODUCTION

• Installing the Course Materials
• Program versions
• Text formats

DEVELOPER TOOLS

• Troubleshooting
• The Debugger

MAPPING TABLES

• Mapping Quarters to the Orders table
• MonthYear
• Cleaning up the table structure

LOADING BUDGET DATA

• Reading Cross Tables

ADVANCED SCRIPTING

• Condition on a field in a table
• Aggregating Data
• Joining tables
• Concatenation
• Preceding Load on Preceding Load

ADVANCED CALCULATIONS IN SHEET OBJECTS

• Set Analysis
• Dollar-Sign Expansion
• AGGR Function

SCRIPTING AND DATA MODELING CHALLENGES

• Link Tables and Concatenated Tables
• Calculating net change within a field
• Functions InDate, Data & DateIslands
• Aggr()
• Class()
• Dynamic Aggregation
• IntervalMatch

DATA MODEL OPTIMIZATION

• Performance Tuning
• Best Practices for QlikView File Optimization
• Creating Incremental Loads

DATA MODEL OPTIMIZATION

• Performance Tuning
• Best Practices for QlikView File Optimization
• Creating Incremental Loads

DAILY AND TRANSACTION BALANCES

• Overview
• Example: Balances at Specific Dates
• Example: Balances for Transactions (in/out)

QLIKVIEW SECURITY 1

• 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

ADVANCED DATABASE CONNECTIVITY

• Custom Data
• SAP Connector

BUSINESS CASE WORKSHOP

• Scenario
• Data Structure

INTRODUCTION

• Target Audience
• Introduction
• Course Logistics
• Notes

QLIKVIEW DEPLOYMENT CONFIGURATIONS

• Company Requirements
• User Requirements
• What configuration to choose?
• QlikView Standalone
• QlikView Server
• QlikView Server & Publisher

INSTALLING QLIKVIEW SERVER

• Components of the QlikView Server installation file 13

LICENSES AND SERVER TYPES

• License Overview
• Server
• Client Access Licenses
• Publisher
• Local Clients

INTERACTION OF SERVER AND PUBLISHER COMPONENTS

• Workflow and architecture of Document Management & Display
• Document Levels: Script, Data & Layout
• Overall Architecture QlikView 10, technical point of view
• Functional overview of main components

SETTINGS OF QLIKVIEW SERVER, THE QEMC

• Settings of the QEMC
• Status
• System
• Users
• Documents

SECURITY

• General Concept of Security
• Security in QlikView

QLIKVIEW SERVER COLLABORATION

• Sharing objects
• How Server Collaboration works
• Management of Server Collaboration
• More granular control of Server Collaboration

TROUBLESHOOTING

• AccessPoint does not work
• The QlikView Web Server service can’t be started
• AccessPoint displays no content
• Details can’t be displayed in the QEMC or QMC
• The QEMC or QMC don’t work at all