QlikView Online Training Course Content
QLIKVIEW_Developer_I
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
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
QLIKVIEW_Developer_II
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
QLIKVIEW_Server_Publisher_I
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
Prerequisites and preparations for installation
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
Fast response times by pioneering in-memory technology
The patented in-memory technology , the analyzed data and reports without waiting QlikView graphed .
Fast implementation times and low costs
Convince yourself of the rapid introduction of QlikView . Contact us to arrange a "SIB - Seeing is Believing" - workshop in which we jointly within 3-5 days first develop indicators and dashboards and bring you closer to the power of QlikView.
Deployment in various applications and devices
Besides showing the QlikView program or web browser is the display on mobile devices like the iPhone, Blackberry, iPad or other tablet PCs already exists.
Can be used in any size of enterprise
The flexible license models (single, Small Business Edition, Enterprise Edition) allow the use in small, medium and large enterprises . An upgrade from a smaller to a larger version of the V Before Using the same technology readily possible.
Fast merging data from different systems
Examples of systems or data sources are:
ERP systems such as SAP, Sage, Infor, Oracle, Agresso, Microsoft Dynamics NAV and AX
CRM applications such as Salesforce, Siebel CRM, Microsoft Dynamics CRM, SAP CRM, Sage CRM and CRM Wice
Microsoft SharePoint Server lists data
A variety of databases such as Oracle, Microsoft SQL, Microsoft Access, MySQL and many more
About Web Services provided data such as current exchange rates, or general sales and trend analysis
Strong Microsoft Office Integration
Is supported by QlikView for the Microsoft Office products including:
Representation of graphs and tables in PowerPoint with full functionality QlikView
Export of analyzes in Excel workbooks
Presentation of reports in SharePoint server with full functionality through their own QlikView SharePoint Web Parts.